|
|
My position now requires me to make spreadsheets.
For whatever reason they have, they want to see the results of my tests in a spreadsheet.
I have about 4 or 5 dozen spreadsheets to create, with similarities and differences among each one.
Do we have a group here on CodeProject that is focused on Spreadsheets ?
|
|
|
|
|
No, we all just ask our resident Excel expert[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I prefer the term "Guru".
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur .
|
|
|
|
|
I can't get E-mail during the day (company rule / stupid / but needed in this case)
Do we have a chat area ?
Lounge is not (as I understand it) appropriate for the nerd-sorts of questions.
|
|
|
|
|
Or try the Q&A[^] with appropriate tags and your specific problem there should be nothing more appropriate than that.
|
|
|
|
|
|
Would you like my personal email address?
That way I am reachable w/o compromising either of our positions.
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur .
|
|
|
|
|
Quote: Would you like my personal email address? Don't know how we could trade them here. Is there a PM (Private Message) facility here on CodeProject ?
|
|
|
|
|
Ummm, I think Bob gives you a link marked Email, at least he does on mine that isn't publicly posted
so if you want to show him yours (ooh err Matron!) it goes privately...
|
|
|
|
|
Dammit, you were a bit faster than me
Veni, vidi, caecus
|
|
|
|
|
Faster, just tried a bottle of Jolt Cola for lunch for the first time
|
|
|
|
|
Click on "Email" at the bottom of Dave's message.
Veni, vidi, caecus
|
|
|
|
|
Thanks Marco, just did that.
|
|
|
|
|
But "our resident Guru expert" doesn't sound right.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
What if I had studied Sikh Holy Men, would that count?
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur .
|
|
|
|
|
Were you trying to cure them, or just find out what made them unwell in the first place?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Well, as our spreadsheet Guru, perhaps you should start a column?
I didn't plan on creating a row if this is too much of a burden.
.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "As far as we know, our computer has never had an undetected error." - Weisert | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Have a look at an open source library called Spreadsheet Light[^].
I have used it to programmatically generate several types of Excel Spreadsheets with great ease using C#.NET.
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
Thank you, way overkill.
I'm just trying to learn how to click the buttons and type into the cells and stuff.
|
|
|
|
|
Oh... Well alright then, ask Dalek Dave.
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
You know that all you have to do is dump the results into a tab-separated file, don't you?
Open a plain-text file, list each set of details (separated with tabs) in a single line, bung a header row at the top, save it as .TSV, open it in Excel, and you've got yourself a spreadsheet.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
These two languages now are linked so they get updated at the same time by the same people. Why do I think one is going to reach it's limit of supportable life sooner than the other. If history is a teacher my bet would be C# as Microsoft have made more money from BASIC over the years my guess would be C# dies first, but what of the Java people. Make me recall an interview I went to some years ago "we use J# rather than any other language as it will have support for longer as it is Java based"...
Glenn
|
|
|
|
|
Looking at this[^] inaccurate picture, I draw the conclusion that no conclusion can be drawn just yet.
MS has done some effort to move people from VB to C# though, so I'm not going to bet against C#.
As for J# though, it is deader than a married man's soul.
|
|
|
|
|
Well that's good, some one thinks the same as me, The J# job I missed a bullet with that one I couldn't get over the arrogance of the "...well it will be supported longer".
|
|
|
|