Is there any way to read data from an xls file during pre install? I want the installer to behave a certain way depending on what is in the xls file.

asked 25 Sep '12, 12:33

jamminjase's gravatar image

jamminjase
1111
accept rate: 0%


InstallBuilder does not provide built-in actions to perform such actions and we do not recommend performing such complex things as reading XLS files and depending on it in the installer. We recommend using XML or INI files and using <iniFileGet> and<xmlfileget>` actions.

However, if the installer is always run on machines where Microsoft Office is already installed, it is possible to run cscript and access Microsoft Office from Visual Basic.

Below is an InstallBuilder sample that unpacks and runs a .vbs script:

<unpackFile> <component>xlstest</component> <destination>${system_temp_directory}\xlstest.vbs</destination> <folder>xlstest</folder> <origin>xlstest.vbs</origin> </unpackFile> <runProgram> <program>cscript</program> <programArguments>/NOLOGO "${system_temp_directory.dos}/xlstest.vbs"</programArguments> </runProgram> <deleteFile> <path>${system_temp_directory}\xlstest.vbs</path> </deleteFile> <showInfo> <text>Output from cscript: ${program_stdout} </text> </showInfo>

Below is an example Visual Basic code of printing value of A1 cell in Sheet1 of xlsfile.xls file in current directory:

Dim ExcelApp As Excel.Application, XlsBook As Excel.Workbook, XlsSheet As Excel.Worksheet Set ExcelApp = New Excel.Application Set XlsBook = ExcelApp.Workbooks.Open("xlsfile.xls") Set XlsSheet = XlsBook.Worksheets("Sheet1") WScript.Print XlsSheet.Cells(1, 1).Value ExcelApp.Quit

link

answered 25 Sep '12, 14:02

wojciechka's gravatar image

wojciechka ♦♦
7.8k61122
accept rate: 26%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×2
×1

Asked: 25 Sep '12, 12:33

Seen: 548 times

Last updated: 25 Sep '12, 14:02

Related questions