Sirius Black
New Member
- Joined
- Dec 9, 2005
- Messages
- 32
Hey all!
I'm running a number of web-based reports. Once the reports are run, I export them to a spreadsheet (only other option is to export to PDF). The reports open in an Excel web-based browser. Some of the reports exceed the 65K row limitation in Excel. In order to capture all data (including the rows exceeding 65K), I need to save the reports as a .CSV file; however, when I do this from the web, and attempt to view the saved file with Notepad, I am still missing the data beyond line 65K.
Last month when I ran the reports, I was able to successfully save the files as CSV, and retain all rows when viewed with Notepad. Problem is I can for the life of me remember the steps I took to save the file. Obviously it's more than simply saving the file as .CSV through Excel.
Thanks,
Sirius
I'm running a number of web-based reports. Once the reports are run, I export them to a spreadsheet (only other option is to export to PDF). The reports open in an Excel web-based browser. Some of the reports exceed the 65K row limitation in Excel. In order to capture all data (including the rows exceeding 65K), I need to save the reports as a .CSV file; however, when I do this from the web, and attempt to view the saved file with Notepad, I am still missing the data beyond line 65K.
Last month when I ran the reports, I was able to successfully save the files as CSV, and retain all rows when viewed with Notepad. Problem is I can for the life of me remember the steps I took to save the file. Obviously it's more than simply saving the file as .CSV through Excel.
Thanks,
Sirius