Excel Alternatives

[Guest]

I need to create a simple excel file via a console application (C#) which is
schedule to run on a perodic basis.
I first attempted to create and XML file, but when I opened this file up in
excel, it took about 25 minutes to load (about 40,000 rows to the excel file
with about 15 columns). Given the amount of time it took to bring up the
file, I did not consider this to be a viable alternative.
I then created a native Excel file from within the application, and this
works just fine when I run the application interactively. When I schedule
the job to run, I run up against a security error. Upon research Microsoft
does not recommed nor support this method.
I could create a comma delimited file, but then the user has to go through
the hassle of parsing the file each month and each time they access the file
(as they have no ability to save their changes.
So what method would be appropriate for being able to launch a scheduled C#
application and creating an excel file?

Thnaks in advance for your assistance!

 

[Guest]

Comma delimitted, but save with .xls extension. That will work for you.

 

[Nick Malik [Microsoft]]

I need to create a simple excel file via a console application (C#) which
is
schedule to run on a perodic basis.
I first attempted to create and XML file, but when I opened this file up
in
excel, it took about 25 minutes to load (about 40,000 rows to the excel
file
with about 15 columns). Given the amount of time it took to bring up the
file, I did not consider this to be a viable alternative.

Any reason you can't create a spreadsheet that links in data from a
database, and then just throw the data to the database? The user will not
have to deal with the same latency and the operations will efficient.


--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--

 

[Adrian Gallero]

I need to create a simple excel file via a console application (C#)
which is schedule to run on a perodic basis.
I first attempted to create and XML file, but when I opened this file
up in excel, it took about 25 minutes to load (about 40,000 rows to
the excel file with about 15 columns).

Hi,
I am a little biased here, since I am a developer of a third party
solution to creating excel files, but I would recommend you take a look
at them. Third-party solutions are faster than automating Excel, do not
require to have Excel installed, and allow for a complete range of
formatting, so you do not have to deploy a 'naked' csv file.

I of course would recommend our solution
(at www.tmssoftware.com/go/?flexcelnet ) since I believe it is the
best, but take a look around, there are a lot of them.

Best regards,
Adrian.