Solved

Export to excel functionality

Posted on 2014-02-22
4
525 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 500 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

When we want to run, execute or repeat a statement multiple times, a loop is necessary. This article covers the two types of loops in Python: the while loop and the for loop.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
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…

773 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