Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - Excel / .Net: Extract a given Range into Picture or X(HT)ML?

Reply
 
Old 09-02-2008   #1 (permalink)
Jörg Battermann


 
 

Excel / .Net: Extract a given Range into Picture or X(HT)ML?

Hello there,

Is there any -reliable- way to extract certain, given ranges in excel
files into either a picture (each) or into proper xhtml? I am asking
because I am currently automating a document transformation from
several hundred thousand xhtml datasets into a .pdf via proper xml +
xsl-fo transformation, but one of the constraints is to open all file://
links that point to .xls files to appear in the .pdf, too.

Now what we had in our old, very very flacky system was opening the
excel files one by one, select the range, use the semi-
stable .CopyPicture(...) method of excel and paste that (from the
clipboard!) into a graphic file etc etc. Which, apparently, is
bullcrap.


Now with all the xsl-fo transformation hotness, we still can use
images -or- proper xml or xhtml for that, but I am kinda lost what
else there is to do beside utilizing the clipboard for only a range of
rows/cells in a excel file without loosing the format and the actual
data.

Does anyone know any reliable, native .net excel/biff reading
libraries that could accomplish this? Or does the Office Interop
actually provide a stable solution for that kinda scenario?


Any help would be greatly appreciated!

Cheers & thanks,
-Jörg

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Extract names of running applications. (Excel) VB Script
How to get in a vbs script the sum of values of a Excel cells in a certain range? VB Script
How to view Excel document without Microsoft Office Excel installe Vista General
Vista ASP.NET 2.0 Cannot open Excel File using Microsoft.Excel 12.0 COM object Microsoft Office
extract vista I can extract vista from the iso file but can not ex Vista General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46