[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Export to excel functionality

Posted on 2014-02-22
4
Medium Priority
?
546 Views
Last Modified: 2014-05-13
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.
0
Comment
Question by:romeiovasu
  • 3
4 Comments
 
LVL 10

Expert Comment

by:Korbus
ID: 39879602
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?
0
 

Author Comment

by:romeiovasu
ID: 39894722
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.
0
 
LVL 10

Accepted Solution

by:
Korbus earned 1000 total points
ID: 39899312
Hmm, I think I saw a similar problem recently,  it had to do with the excel version of the output file.   They needed to output to a more recent file version, and it worked fine.

hmm, I don't see the sample you attached.

Sorry, that's all I got :(
0
 
LVL 10

Expert Comment

by:Korbus
ID: 40061076
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
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question