C++/VB - create Excel spreadsheet without loading Excel
Asked By sneaky hamster
20-Oct-08 04:03 PM
Greetings,
I have a script which uses CreateObject("Excel.Application") to create a
spreadsheet. This works fine on my machine since I have Excel loaded.
I plan to move the script to a server & would like to avoid loading
Excel on that machine. Is it not possible to just put certain files
(DLLs?) on the server without performing a full install?
Thanks
Excel
(1)
VBScripts
(1)
Database
(1)
DLLs
(1)
CreateObject
(1)
Salvador
(1)
Manaois
(1)
Badz
(1)
Al Dunbar replied...
I doubt it. An application consist of its files plus the fact that it is
installed, a process which registers its application object.
/Al
SalvadorManaoisII replied...
You can install the Excel viewer to open, view, and print Excel workbooks,
even if you don't have Excel installed. You can also copy data from Excel
Viewer 2003 to another program. However, you cannot edit data, save a
workbook, or create a new workbook. This download is a replacement for Excel
Viewer 97 and all previous Excel Viewer versions.
http://www.microsoft.com/downloads/details.aspx?FamilyID=c8378bf4-996c-4569-b547-75edbd03aaf0&displaylang=EN
--
Salvador Manaois III
MCSE MCSA CEH MCITP | Enterprise/Server Admin
Bytes & Badz : http://badzmanaois.blogspot.com
Paul Randall replied...
ekkehard.horner has posted a number of VBScripts that create and manipulate
Excel and Access spreadsheet and database files, without the use of the
Excel or Access applications. Groups.google.com can find them for you
easily. Go there and search for the following:
ekkehard create xls vbscript group:*.scripting
-Paul Randall
C++ / VB Internatinalization and multiple language support without resource DLLs Hello I'd like to support multiple languages for my MFC application (GUI elements, message strings, menu items). I don't want to use the resource DLLs because my client want to provide additional languages without neccesity of recompilnig new dll per I have googled but didn't find any other ways for MFC than using resource DLLs. Is there a standard solution for this? Thanks Dominolog I'm not sure if there in messageboxes). For resources like dialogs etc it is recommended to create so called 'satellite dlls' for each language that contain the resources for each language. There are many tutorials available schrieb: Hi Dominolog, appTranslator is your friend: Among many other goodies, it creates the resource DLLs for you. Your client won't need a compiler to create them. They just type d have to load each control at run time. The nice thing about resource (satellite) DLLs is that you can add them when you want them and leave them out if such that his client must not / can not use the compiler to build the localized DLLs. So, I think that Serge's appTranslator tool can be the answer to the OP small so it will not matter that much. Tom Yes. The standard solution is resource DLLs. It is considered "best standard practice" and there are good reasons for it. Any other
C++ / VB system32 \ tskill.exe And EXCEL by VBS file. . . Hi. I got a job about writing some txt files into a Excel sheet. Some text1: value1 Some text2: value2 . . . and so on. . . So today I wrote a A problem I found was that if one said something wrong to the msgBoxes from Excel, or whatever, then it could freeze the sheet. . . To avoid that, I simply used the Say No to the first question, and the freeze problem is gone :) My knowlede about Excel syntax is almost one line, something like this: oExcelSheet.cells(1, 1).value so any oTargetFile, oFi, sR, iU _ , arr(), arr2, s0, s1, iRowBeg, iRowEnd, sVer, bNewSheet set fso = createObject("scripting.fileSystemObject") set wso = createObject("wScript.shell") sub BeginCScript(bDebug, bMaxWin) if "WSCRIPT" = uCase(fso.getBaseName(wScript.fullName)) then if if not fso.folderExists(sTargetPath) _ then fso.createFolder(sTargetPath) ' sExcelEXE = "%ProgramFiles% \ Microsoft Office \ Office10 \ Excel.exe" sExcelEXE = fso.getAbsolutePathName(wso._ expandEnvironmentStrings(sExcelEXE)) if not fso.fileExists(sExcelEXE) then sExcelEXE = "excel.exe" ' sVer = fso.getFileVersion(sExcelEXE) if sVer = "" then sVer = "?" ' wScript.echo """excel.exe"", ver " & sVer
there a simple way to create a script that will open up the file in Excel with the first 5 values in worksheet 1, the next 3 in worksheet 2, and use the ADO objects to create the .XLS with the multiple sheets, without involving the Excel object? I think I have a script to create .MDB files directly with ADO hidden Dim objFSO, objExcel, objWb, objRng Dim objTextFile, CSVdata Dim d, sheet, row, col Set objFSO = CreateObject("Scripting.FileSystemObject") Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.Workbooks.Add Set objWb = objExcel.ActiveWorkbook Set objTextFile = objFSO.OpenTextFile n = 20 [. . .] I really like this idea. This demo script Dim oFS : Set oFS = 3D CreateObject( "Scripting.FileSystemObject" = ) ' Config: change according to your system ' sTDir must exist, sMFSpec should point to sTDir & " \ schema.ini" Dim sXFSpec : sXFSpec = 3D sTDir & " \ impadoexcel.xls" Dim oADOCN : Set oADOCN = 3D CreateObject( "ADODB.Connection" ) Dim sCS : sCS = 3D Join( Array( _ , "Driver = 3D{Microsoft Text Driver (*.txt UBound( aParms ) Step 2 sSQL = 3D Join( Array( _ , "INTO [" & aParms( nIdx ) & "]" _ , "IN '" & sXFSpec & "' 'Excel 8.0;'" _ , "FROM " & sTblName ), " " ) WScript.Echo sSQL oADOCN.Execute sSQL Next oADOCN.Close works
DOC itself. r u getting me? thank you For any inserted Office document, examples include Excel Spreadsheet, Power Point Presentation, Visio, etc., extraction is easy. These documents can all be extracted load and save these documents. Use CoCreateInstance to instantiate the OLE Auomation Application(i.e., Excel, Power Point, Visio, etc). I gave the recipe in one of my previous posting in your thread. The only problem with excel files is that once extracted they are invisible. You must make them visible to see group / microsoft.public.dotnet.framework.interop / browse_thread / thread / 2ce134250d3d061b / 64d73629838242f4?hl = en&lnk = st&q = excel+michael+phillips#64d73629838242f4 I have not tried inserted images. However using the DFViewer, I see me say by computing binaries only? Also i viewed the code you provided to extract excel, i suppose it do not require creating an instance of EXCEL. Is this true? By reading the compobj i figured out if the excel Workbook stream is BIFF8, is this the right way to probe BIFF format? Also i previous post on this thread will eventually achieve this goal. You can either use the Excel COM Automation API or the method that I provided. You still need an instance of