Import from excel function is used to get data from an excel file.
Sheetkraft contains the data from excel option which can be accessed by the Import From Button present in the SheetKraft Toolbar ( See figure)
The following guidelines describe how data can be imported from a particular workbook using Data From Excel.
Click on the Import From Button and select the Excel option to open this dialogue box.
Click on the browse button as shown in the above picture and if the file location is relevant to the workbook’s location, click on the checkbox and browse for the relevant workbook from where the data is to be imported.
Select the sheet from where the data is to be imported, you can change the sheet by clicking on the change sheet option and then choose the range as shown below:
Pro Tip: Choose the range to import in the RegionDown/RegionAcross/RegionRight format. This is useful when the data keeps changing. Sheetkraft, by default, imports the data in the RegionDown format.
The Column Specification section consist of the following: Match Text: It contains the text that you want to match with the column header. Match Type: This helps to depict the type of the match text. This further contains the following:
Match Index: Thishelps to make the field required, optional, All Headers or All values. You can choose it by the dropdown option provided.
If Blank: This contains the content that will be displayed if the cell is blank. The default content that is displayed is #VALUE.
If Error: This contains the content that will be displayed if the cell has an error. The default content that is displayed is #N/A.
Header: This shows the header of the column. You can edit the header according to your convenience.
The picture below represents how the table would look like.
Follow Step 1 and Step 2 from Case 1.
Select the range which has the sheet names specified in the “Specify sheet(s) by name or range option.”
In the range section, choose the range from any one of the sheets in the region down format and click on OK .
Follow Step 1 from Case 1.
Use the GetAllFiles option to get the relevant file locations that are to be imported.
In the UI of DataFromExcel, change the import values from a single file to multiple files and choose the range of file locations which was obtained in step 2.
Follow step 3 from Case 1 if there is only one sheet which is to be imported.