Last post Sep 21, 2010 07:24 AM by dharmbirsingh
Mar 02, 2009 08:50 AMemail@example.com|LINK
I am using a function to save dataset tables to excel files (some xml method http://www.codeproject.com/info/search.aspx?artkw=xls+to+xlsx&sbo=kw ) in xls format(excel 2003) but the excel file which is created taking 10 times more file size than conventional
And after that when I am converting to excel 2007 format I am getting the normal size for that file.
Now can anyone tell me how to convert excel 2003 file format to excel 2007 file format programmatically through asp.net
Thanks everyone in advance.
Mar 02, 2009 11:20 AM|DigiMortal|LINK
Mar 04, 2009 02:07 AMfirstname.lastname@example.org|LINK
I did exactly like u said i.e
1 created excel 2007 object
2. opened excel 2003 file
3. Called SaveAs() method with 2007 object
I was not in office during this post , I will post the code later.(subsequent post)
I worked me.
The thing is that the function looks like:
1.Writing the entire data to excel sheet through xmlwriter class
2. Save it in temp folder in my application in excel 2003 format (which nearly takes 360MB for a 90,000 Records)
3.Then saveas in excel 2007 format (now converted into 50MB something original value)
4.Then deleting the excel 2003 format for the next file to be saved.
The above steps I am following and I am getting the required solution for my query.
I can guess that I am not following the standard procedure but there is no other way to save the 1lakh records directly to excel 2007 format directly throgh vb.net.
Any way thanks for your post it helped me a lot.
Nov 09, 2009 10:33 AM|BarbaMariolino|LINK
You could try using GemBox.Spreadsheet
.NET excel library for
reading and writing XLS, XLSX, ODS, CSV and HTML formats.
Here is an example how to
convert from XLS to XLSX with GemBox.Spreadsheet library.
Sep 21, 2010 07:24 AM|dharmbirsingh|LINK
I also having the same requirement could please guide me with this.