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
one.
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
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.
vamshi455@gm...
Member
2 Points
3 Posts
How to Convert Excel 2003 (.xls) format to Excel 2007 (.xlsx) programmatically in asp.net
Mar 02, 2009 08:50 AM|LINK
Hi everybody
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 one.
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.
DigiMortal
Contributor
5658 Points
939 Posts
MVP
Re: How to Convert Excel 2003 (.xls) format to Excel 2007 (.xlsx) programmatically in asp.net
Mar 02, 2009 11:20 AM|LINK
Also visit my ASP.NET blog or follow me @ Twitter:twitter.com/gpeipman
vamshi455@gm...
Member
2 Points
3 Posts
Re: How to Convert Excel 2003 (.xls) format to Excel 2007 (.xlsx) programmatically in asp.net
Mar 04, 2009 02:07 AM|LINK
Hello DigiMortal,
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.
Regards,
vamshi singam.
BarbaMarioli...
Member
208 Points
136 Posts
Re: How to Convert Excel 2003 (.xls) format to Excel 2007 (.xlsx) programmatically in asp.net
Nov 09, 2009 10:33 AM|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.
dharmbirsing...
Member
4 Points
2 Posts
Re: How to Convert Excel 2003 (.xls) format to Excel 2007 (.xlsx) programmatically in asp.net
Sep 21, 2010 07:24 AM|LINK
Hi vamshi,
I also having the same requirement could please guide me with this.
Thanks
C# 3.5