asked on

Export to excel functionality

Hi all,
In my current project's website(technology: .net (mvc), I have a web page which exports huge data(more than 10000 rows) to excel.
It works fine on localhost. but, not on the server.

We tested below things.
1. If any corrupt data is blocking export functionality.
2. In web.config <httpRuntime maxRequestLength> is proper.

Result of above testing was No Currupt data & maxRequestLength is enough.

Then we tried testing bunch of data, say only 5000 rows, then 7000 rows etc.. Export went good till it reaches to 10000. If data is more than 10000, it exports 'blank' excel.

I am not able to figure out why the same code is not working on the server.

Please provide an expert advice how to re-solve it.

Korbus

Not clear exactly what is not working on the server as opposed to workstations. Is OPENING the final file the problem, or is it the actual file GENERATION? (I think I'm confused because you have results of a website generated on a local machine- how exactly is this working? Is it connecting to the server?)

Second question: does the excel file exist, and you are modifying it, or are you creating a new excel file?

romeiovasu

ASKER

Hi, Korbus. Thanks for the response.

I am creating fresh excel file each time. It is connecting to the server and making an excel file. If data is more than 10k rows, then it is only creating an excel file with blank data with 9kb size and sheetname is set to any random name. ( I have attached sample excel that the server is creating when data is more than 10k rows)

Reply.

ASKER CERTIFIED SOLUTION

Korbus

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Korbus

Hi Romeio,

If the solution I posted did NOT work for you, and you no long need assistance; please request attention, and delete the question (for future searchers).
If the solution worked, could you please let me know why you graded the answer with a "C"?

Thank you,
Korbus