While it works fine on most computers, it simply doesn't work on some computers. This is a complicated process, requiring the coordination of Excel, Prism, and various Windows components. Importing an Excel file requires an OLE (Object Linking and Embedding) connection between Prism and Excel. Because Excel has to be launched in the background, importing an Excel file can take much longer than importing a text file. So Prism can only import an Excel file if Excel is available on the same computer as Prism. When importing data from an Excel file, Prism launches Excel invisibly, and asks Excel to send the data to Prism. Any other worksheets are invisible to Prism. If your Excel workbook (spreadsheet file) has several worksheets (tabs), Prism only reads one – the one that was selected when the file was saved. Limitations to importing Excel files directly Prism will show you the Import and Paste Special dialog, which will let you choose whether to embed or link to the original file, and also will let you filter and rearrange the data as you bring it into Prism. Whenever possible, transfer data from Excel using copy and paste. Click on the Import button on the Prism toolbar. Start from a data table and move insertion point to the cell that will become the upper-left corner of the imported data. To import data into Prism (Windows only) directly from an Excel XLS file:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |