|
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
|
|
|
|
|
Not had CBS for a while now and can't say I've missed it. No idea whose fault all this is - TWC for not wanting to pay for it or CBS for asking too much.
However, in an effort to placate the revolting masses TWC have just sent me a voucher for a free on-demand movie. If they sent this to all of their customers and everyone took them up they'd be better off paying what CBS wants with the fees they'd lose (I think they charge $15 for films tho not sure)!
They also offered everyone a free antenna to watch CBS.
To be honest, I really don't care if they never get CBS back but I will watch a free film.
Perhaps I should rethink the plan and just get internet and subscribe to Hulu - be cheaper, that's for sure.
"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
|
|
|
|