A good idea would be to record a macro in Microsoft Excel and then convert it to Perl. But here is a complete example:

A complete example that opens an Excel workbook, loops through all the charts and saves them as GIFs and then closes the Excel workbook is here: Win32::OLE->new('Excel.Application', 'Quit'); # use the Excel application if it's open, otherwise open new See similar questions...

If you don't have the appropriate Microsoft software you can still view the files (Powerpoint, Word, Excel) by downloading the FREE viewer from Microsoft. Go to these websites for the appropriate viewer: Additionally, some other software programs allow you to open certain types of files. The old Microsoft Works bundle can readily open Word and Excel files. Microsoft Wordpad (included with all versions of Windows) can open Microsoft Word documents. See similar questions...

XLSTAT is permanently being tested with all existing Excel versions. The Mac version runs with all Excel version from version 5.0. The PC version runs with all Excel versions starting from version 97. Whatever your Excel or XLSTAT version, it is necessary that the Macros security level (see menu Tools/Macros/Security of Excel) is set to Medium so that XLSTAT can run. Excel 97 SR-1 users: your Excel version must be updated. Version SR-1 is buggy and you need to upgrade to SR-2. See similar questions...

Yes, raw data in the CSV format can be imported into Excel. This works without any problems. Try it by logging in as user "demo" with the password "demo" and generating a raw report. If one of your respondents associated a password with his response and decided to edit it one or more days after first entering it, it is no longer included in the response count for the date of its creation, but for the day when it was last modified. See similar questions...

If you do not have Microsoft Excel there is software available which enables you to read Microsoft Excel documents at no cost. You can download this free software at: http://www.openoffice.org/ See similar questions...

Alt+Page up moves to the prior screen and spreadsheet, while Alt+Page down moves to the next screen andspreadsheet. Ctrl+Down arrow, Ctrl+up arrow, Ctrl+Left Arrow and Ctrl+right arrow move the cursor to the edge of the current data region. See similar questions...

Use the Names->Add method on a sheet, giving it a name and a range object to apply the name to, for example: See similar questions...

The binary file format of Microsoft Excel documents is extremely complex. If you want to reproduce this format in detail and with precision you should read OpenOffice.org's Documentation of the Microsoft Excel File Format. To display HTML output in plain text format, you must set the HTTP Content-Type header to text/plain, as below: See similar questions...

During eDoc™’s installation, a toolbar is added in Microsoft Word, Microsoft Excel and Microsoft PowerPoint. The toolbar is called "eDoc™ bar" and has two buttons: 1. "Send to eDoc™" 2. "Get from eDoc™" This way you can access eDoc™ functionality within MS Office applications. See similar questions...

Sunfrog is purpose-built for one task: scheduling your production. Sunfrog's call sheets and reports are specifically tailored for the film industry - you don't have to design your own from the ground up. Sunfrog lets you create the best schedule without knowledge of Excel formulas or macro programming. Filmmakers often want to tweak their documents in other applications. That's why Sunfrog supports export for Word, PDF and HTML. See similar questions...

No. Nor do we have SoftWindows that emulates an Intel machine on our SGI. If you really need to use these applications, use the PCs. See similar questions...

We chose to implement CONTROL's primary user interface in Excel because it is the tool of choice for our user community. Wherever possible, we designed CONTROL's functionality to work consistently and similarly to Excel features, both to leverage the incredible power of Excel and minimize training time. Since both CONTROL's user interface and processing engine are based on leading-edge Microsoft technology (e.g. See similar questions...

Excel is hugely powerful as a stand-alone program. Rather than us trying to recreate all Excel can do by itself, we’ve chosen to piggy-back and let Excel work for us (and you!). 2. Most people in the construction industry are already familiar with Excel or other spreadsheet programs. This limits the learning curve with our programs. 3. Excel enables many cool features such as split screen, in-cell equations, variables, etc. that YOU can take advantage of. See similar questions...

To import Excel data in Sigview, save it as "Tab delimited (*.txt)" file from Excel. You should remove all unnecessary headers or additional text from the sheet before you do that. You can import such files in Sigview by using File/ASCII/Import... menu option. To import Sigview data in Excel, save it as tab delimited file by using File/ASCII/Export... menu option, and load those in Excel as Text-file. See similar questions...

If you have a sheet object you can extract the values of a series of cells through $Sheet->Range->{'Value'}, for example: Now $array[0][0] contains the value of cell A8, $array[0][1] the value of cell B8, $array[1][0] the value of cell A9 and $array[1][1] the value of cell B9. What is returned is an two-dimensional array (OK, an array with references to arrays) that contains the values of the requested cells. See similar questions...

If you use Microsoft Internet Explorer as your browser, just go to the File menu and choose "Edit with Microsoft Excel" when viewing a TimeTiger report. If you're using another browser, just save the numbered HTM file to a convenient location using your web browser, then open it directly from Microsoft Excel. You will be able to view it and edit it in Excel, all formatting intact. Back to top See similar questions...

Once you have successfully executed a case, the results toolbar will be displayed. You can press the Results With Buildup button or the Results Without Buildup button to display the results window. While this window is active, you can select the File Export menu and choose between exporting to Excel or Word. See similar questions...

To quickly create an org chart from your existing Excel data, download our step by step instructions located here. See similar questions...

CRBcharts can compress the data for the chart you have on screen. Click Utility, Compress, or click the Compression button on the tool bar and select Weekly or Monthly and the data will be compressed and the chart re-drawn as a compressed chart. See similar questions...