Hi There,
I have some serious issue - I have a .Net application that is generating various reports in CSV format and then fires up excel from code to view this file.
The file is viewed properly and everything is alright (I make some calls from within my code to the Excel Interop)
I Couldn't find any call that will allow me to set records from "General" format to "Text" format. the reason I need to do this is since I have records with very long numbers , and I need to display these numbers fully - but excel "Truncates" them to something like "3.232e" and stuff like that.
Is there any solution to this issue ? It is quite important to me but I couldn't find anything on the web.
Thanks in advance.
I have some serious issue - I have a .Net application that is generating various reports in CSV format and then fires up excel from code to view this file.
The file is viewed properly and everything is alright (I make some calls from within my code to the Excel Interop)
I Couldn't find any call that will allow me to set records from "General" format to "Text" format. the reason I need to do this is since I have records with very long numbers , and I need to display these numbers fully - but excel "Truncates" them to something like "3.232e" and stuff like that.
Is there any solution to this issue ? It is quite important to me but I couldn't find anything on the web.
Thanks in advance.