Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Export to excel functionality

Posted on 2014-02-22
4
Medium Priority
?
543 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

If you haven’t already, I encourage you to read the first article (http://www.experts-exchange.com/articles/18680/An-Introduction-to-R-Programming-and-R-Studio.html) in my series to gain a basic foundation of R and R Studio.  You will also find the …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

618 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