Solved

Export to excel functionality

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now