Data Import

23.08.2021

To import data into a spreadsheet, you can read the data from a text file, for instance, which will then be more or less copied "as is" into the spreadsheet.

FlexPro features import filters for a wide variety of binary file formats for measuring devices and data acquisition application as well as a wizard for text and Excel files. You will have to give the wizard some information about the file structure, which you may already be familiar with from working with spreadsheets. The result, however, is always a series of data sets that are displayed in the Object List.

You can use the Excel File Import Wizard to import data that is arranged in columns or rows directly from Microsoft Excel XLS or XLSX files. Excel does not need to be installed on the machine for this type of file import. An alternative is to import entire Excel workbooks into the FlexPro project database and work with Excel in the project database. You need to have Excel installed to do this. To access data in an Excel workbook imported this way, create Excel data links.

In addition to data, FlexPro also transfers information such as units and comments. You can copy data to the FlexPro project database or create links to the original data. If you work with links, changes to the original files immediately affect the analysis results in FlexPro.

FlexPro can exchange data directly with other programs as well. You can export data in other program formats and use the FlexPro OLE data link to exchange data in both directions dynamically.

Next Topic

Using Data in Calculations

Share article or send as email:

You might be interested in these articles