|
I'm not interested in getting programming answers here, of course, but I could use some guidance on where to look for answers to a programming problem I have at work. As you can imagine, not much useful stuff comes back when I Google for "how do I programmatically export a single worksheet in an Excel workbook to a .csv formatted file without opening Excel?" Lots of responses, of course, but far more chaff than wheat...
That, in a nutshell, is what I want to do, but I really don't want to have to deal with VBA. I'm certain there's something in the .Net world that will allow me to do this with C#, but I haven't a clue anymore where to look. As I've mentioned, I'm trying to automate the process of monitoring our electric utility's efficiency using, as part of the process data, the reports I get from suppliers. As it turns out, the daily emails I receive are worthless, as multiple sources have low precision, and rounding errors are killing me. The only other source is a monthly spreadsheet I receive, but only one sheet of the total package is relevant. On a positive note, this spreadsheet data is all normalized to a common precision and audited for errors. I want to offload this crap to some other sucker in the office, but none of them have enough computer savvy to get it right if I ask them to open the workbook and manually export the useful sheet to the specified folder for processing. I need to make this whole shebang as automatic as possible if it's going to work at all, or I can look forward to doing this mind-numbingly boring task myself for all time to come.
Where should I look to learn to do this task?
Will Rogers never met me.
|
|
|
|
|
Have you looked at Office Interop? I've never tried exporting a worksheet with it before, but I would guess that it's possible. And I know for a fact you can hide the UI (IIRC, you only need to set a flag).
There's also a way (not sure if it is part of interop or not) to treat an Excel document as a database, with each worksheet being a table. I've never worked with it (never needed it, and it seems kinda awkward), so I don't know all the ins and outs. If you're interested, I can see if I can dig up some more info to get you started.
What is this talk of release? I do not release software. My software escapes leaving a bloody trail of designers and quality assurance people in its wake.
|
|
|
|
|
Well, I can't tell you where to look, but I'd tell you how I'd do it and from there you can look up the pieces.
First I'd read the excel sheet into a datareader using OleDB. The sheetname equals the tablename in a database.
Then I'd read every record from the reader into a string array and copy this array into a CSV file using String.join(",",array) (assuming dotnet 4 here)
Be excellent to each other. And... PARTY ON, DUDES!
Abraham Lincoln
|
|
|
|
|
I had to do something similar a while ago, and found this site[^] (AIRI, it looked even worse, then).
I had to download the office.interop library; I'm not sure you have to, any more.
I do remember it being bloody fiddly and annoying, though, so good luck.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
epplus project at codeplex.
/Fredrik
|
|
|
|
|
|
So basically, you do not want to open a spreadsheet once in a month to export its content to a .csv file ?
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
|
My mother just got our dogs a large orange ball with a handle. So far, so good. BUT! The ball smells like chocolate doughnuts.  How on Earth.....
brisingr_aerowing@Gryphon-PC $ rake in_the_dough
Raking in the dough
brisingr_aerowing@Gryphon-PC $ make lots_of_money
Making lots_of_money
|
|
|
|
|
It makes you wonder how they make chocolate doughnuts smell like large orange balls, doesn't it?
Will Rogers never met me.
|
|
|
|
|
Forgive me, but I don't think I'll be going round sniffing dogs' balls to see if they smell like doughnuts.
It probably explains a lot about dogs' behaviour, though.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
The smell is strong enough that it can be sensed about eight feet away. My mom and I were trying to figure out where my dad was hiding doughnuts when I noticed (while holding the ball) that it smelled like that.
I really want to know WHY the company did that.
brisingr_aerowing@Gryphon-PC $ rake in_the_dough
Raking in the dough
brisingr_aerowing@Gryphon-PC $ make lots_of_money
Making lots_of_money
|
|
|
|
|
Can anyone else smell it?
|
|
|
|
|
test
modified 26-May-21 11:54am.
|
|
|
|
|
You must have a huge pair attached. My wife would kill me if I published a picture of my girlfriend. 
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
He's not scared of your wife...
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
In that case he is indeed a very brave man. 
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
SoMad wrote: My wife would kill me if I published a picture of my girlfriend.
His algorithm might have taken into account that collision as well.
Signature construction in progress. Sorry for the inconvenience.
|
|
|
|
|
Or perhaps the following quote from his article indicates he is on the path that leads to the dark side. 
Quote: In this way you will be your own god and you will go as far as your mind takes you.
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
I have not been into 3d for a long time, but does DierctX still not handle CD by itself ?
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
Michelle was watching it, honest guv, I just happened to be in the room the whole time it was on!
Footloose, a film I haven't seen in about 20 years.
My only defence is that it contained a lot of bacon.
Now watching AVPR, another guilty pleasure!
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur.
|
|
|
|
|
Footloose never really did it for me, but I do like some of the cheesy movies from back then. They take me back to a simpler time with no mortgage, no Internet and my dad's cell phone was as big as a suitcase. 
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
Dalek Dave wrote: it contained a lot of bacon.
Yes, but this type of bacon is not particularly tasty ! 
|
|
|
|
|
...to browse the NuGet Gallery.
I found this[^], this[^], and this[^].
I know I can find uses for these in a project I am working on right now.
brisingr_aerowing@Gryphon-PC $ rake in_the_dough
Raking in the dough
brisingr_aerowing@Gryphon-PC $ make lots_of_money
Making lots_of_money
|
|
|
|
|
Good finds. 
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Those who seek perfection will only find imperfection
nils illegitimus carborundum
me, me, me
me, in pictures
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
