|
Hmmm...[reading the fine print] Well, it doesn't say that I can't do that, so...
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
ExcellentOrg wrote: today's post-feminazi world
Great phrase ! I'd love to re-use it, but this will not be on the best effect in Germany.
~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
|
|
|
|
|
Never byte more that what you can chew.
"Real men drive manual transmission" - Rajesh.
|
|
|
|
|
I'll nibble on those words for a while.
This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre.
Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.
|
|
|
|
|
Well, on 64 bit machine, at the very least, it would be 8 bytes at a time....
-------
Real men quit driving and long since walked/trotted away into the oblivion ....
|
|
|
|
|
<grey>(I understood it, definitely making progresses...)
Veni, vidi, vici.
|
|
|
|
|
Magnificent. Is he sending one byte at time while writing data as well? Must be so much fun uploading huge files to your database.
"Bastards encourage idiots to use Oracle Forms, Web Forms, Access and a number of other dinky web publishing tolls.", Mycroft Holmes[ ^]
|
|
|
|
|
Will know soon enough when I get to see the writing side. Holding onto a little hope because the other code was written by a different person (who incidentally has left few months ago)
|
|
|
|
|
ExcellentOrg wrote: In a production code Anything starting with that is going to be good.
And it didn't disappoint.
|
|
|
|
|
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')
|
|
|
|