Solved

Export to excel functionality

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VS 2017 18 105
Exception when using Alea null reference in fsharp.core.dll 3 52
itextsharp with c# 3 18
.NET - find out if application is running on Windows 2012 server 3 35
Windows Script Host (WSH) has been part of Windows since Windows NT4. Windows Script Host provides architecture for building dynamic scripts that consist of a core object model, scripting hosts, and scripting engines. The key components of Window…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.

749 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