This works for me, using the Excel 9.0 object:
// create Excel Automation Object
Excel.Application xlObj = new Excel.Application();
// open the spreadsheet
Excel.Workbook wb = xlObj.Workbooks.Open(FILENAME,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing...
What I did was write a C# application which uses COM automation. It opens the Spreadsheet, iterates through all visible worksheets, prints them to a PostScript file. Then, it automates Distiller to convert the PostScript to PDF.
Round-about, but it works great.
Thomas D. Greer
www.tgreer.com
All Windows Form or Console applications, C#.
Yes, it's difficult. I develop the Class Libraries with an extra Console Project that acts as a test harness.
Then when testing is completed, I compile a version as a DLL without the console project, and "publish it". The other developers then add...
I've always been a "lone wolf" programmer. Now I'm coding class libraries for a large company. These libraries will be used in lots of other applications (goes without saying, doesn' it)?
My question is, if a particular class library ends up being used in 16 different applications, and I update...
No issues with dual VS versions here, either. Though, this is perhaps a side issue, I did find that the .NET Framework 1.1 security policies didn't automatically transfer to .NET Framework 2.0.
All of my applications for a certain client run from network shares, so I have to alter the...
I just realized I never gave you stars for this Chip. You're right, creating a class for the Document, and then implementing a list of Document objects, is the proper way to do this. Thanks again.
Thomas D. Greer
www.tgreer.com
An ArrayList might work, if it were type-safe.
One program/class processes the file and generates all of the keys / records all the byte positions. What determines a page/document differs with every file, so it has to process a lot of rules and expressions as it reads through the file.
Then...
Yes, I could.
If I have a dictionary, hashtable, or list of byte offsets:
Document 1 starts at byte 10671 in the file.
Document 2 starts at byte 888912 in the file.
and I want to store Document 1 in a string, then I need to retrieve both values, and calculate the bytes to read.
For reasons...
A follow-up question then would be, given either a specific key or value for a dictionary item, is it possible to determine the index of that entry?
In other words, given:
_dictionary["somekey"] is the 1st item in the dictionary, how would you return "0"?
Thomas D. Greer
www.tgreer.com
Very nice story, indeed.
My only thought is that this puzzle might not be Christmas-themed at all, but since it's the last puzzle , and comes on the heel of the confession, something about "to tease"? (2 teas).
Thomas D. Greer
www.tgreer.com
Phrases, jingles, rhymes - all always run through my head. You jogged a memory of a vacation roadtrip where a little ditty came to me as I drove under an overpass:
My wife is fast asleep
all the kids are gassy -
I'm stuck behind a pick-up truck
with a cock-eyed chassis.
Thomas D. Greer...
I don't have to maintain sequence, per se. I need to be able to get any arbitrary document, or any arbitrary page within the document or file.
I'll look at List<>, thanks for the suggestion.
Thomas D. Greer
www.tgreer.com
I'm starting a new project, and trying to come up with the best way to store some data.
I'm processing large binary files. These are print-streams. Each file will contain many documents, and each document will contain a differing number of pages. At some point I'll need to re-sequence documents...
Hmm. I see the teriminology, yes, but the only way for a page to send a "request" to a server is via HTTP Get/Post or the XmlHttpRequest object. To keep the page "live in the client browser" while sending and a processing a separate request is known in the web development community as "AJAX"...
But you can see from that code that a true "callback" isn't being done. The textbox is coded to run on the server, and the server code runs each time a key is released. You can call it a "callback" if you wish, but it's really just an HTTP Post.
Nevermind, it's just semantics I suppose...
You cannot, strictly speaking.
You can use AJAX to generate a second, "hidden" request via the XMLHTTPRequest object. Sorry, I don't have a VBScript example.
The web doesn't support "client callbacks", only HTTP Get and Post, period.
Thomas D. Greer
www.tgreer.com
I heard that the most common given name in the world is "Mohammed", and the most common family name is "Chang". Yet, I've never met anyone named "Mohammed Chang".
Thomas D. Greer
www.tgreer.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.