I do not have Excel installed on my server, it is installed on the PC that will be exporting. I am wanting to export the dataset to Excel, but am unsure of how to do such as we have Excel XP, Excel 2000, Excel 2007 and Excel 2013 being used. How can I export w/o targeting a specific Excel version so that it works on all computers?
-
1you can use CSV file it works in all excel version– Satinder singhCommented Jun 29, 2015 at 16:37
-
1Just use a library such as EPPlus, NPOI, or Open XML SDK to generate a .xlsx file. See How to open new file formats in earlier versions of Microsoft Excel.– masonCommented Jun 29, 2015 at 16:37
-
@mason can you provide syntax?– Bob GoblinCommented Jun 29, 2015 at 16:38
-
@user2676140 No that's too broad of a request. You are perfectly capable of looking at the examples those tools provide.– masonCommented Jun 29, 2015 at 16:38
-
Using this option would I Be able to set row height?– Bob GoblinCommented Jun 29, 2015 at 16:40
|
Show 1 more comment
1 Answer
The most portable format is .csv which will work on all platforms but will only work for simple data.
If you have more than simple data you can just export to the oldest version of excel you want to support, the newer ones will then upgrade the file.