Export To Text
Export to Text function is used to export data into text file(s) as well as CSV file(s).
SheetKraft contains the Export to Text option which can be accessed by the Export Button present in the SheetKraft Toolbar (See figure)
Case 1: Basic Example:
The following guidelines describe how Export to Text is used.
Click on the Export Button and select the Export to Text option to open this dialogue box
Select the data that needs to be exported. There are two ways by which you can select the data:
By manually selecting the data from the sheet.
By entering the cell indices of the starting and ending block, for example $A$1: $L$800.
You can select Change sheet if you want to select data from some other sheet. Also, click on the My data has headers checkbox if you have selected the headers with the data. After selecting the data, click on OK.
The dialogue box shown below, opens
Check the File has headers box if the data headers need to be copied to the text file.
If the data needs to be exported to multiple text files, check Partition the data box and follow the steps in CASE 2.
Select the delimiter to be used from the Delimiter drop-down window. By default the delimiter will be Comma.
User might want to consider certain values in the data as a BLANK field. The value can be provided in the field provided.
Also, if a user wants to Add certain data in an existing file. Click on Append to the file in the field provided.
Under Column Specifications, preview of the data to be exported will be displayed. The columns can be reordered by selecting a column and drag it across the table. Each column contains a checkbox next to it. All the columns to be exported should be checked.
Corresponding to each column there is a Format field. Format field allows users to specify a format for a given column. SheetKraft tries to identify the formats for each column.
For each column we can use Export Condition. Export Condition allows the user to specify a condition for each column.
After specifying the columns, select the location of the file or folder (in case of multiple files) into which data needs to be exported by hitting on the browse button under Destination.
After entering all the specifications click Next.
You will be asked where to save the result. To write the result in the Existing WorkSheet, you can input the index of the starting cell where you want to write the result. Or you can write the result in a New Worksheet.
After entering your choice, click Finish
The figure displays the open text file into which data was exported. The data in the text file is ","(comma) separated and contain headers.
Case 2: Export to Multiple Files:
Repeat the steps step 1 to step 3 in CASE 1.
For the data to be exported to multiple text files based on the value in a particular column, check Partition the data box.
Then two new fields appear: Partition By and Into Files.
Partition By drop-down contains the name of all the data columns. Select the column based on which data needs to be partitioned.
In the Into Files field specify the format of the file names '*' in the format will be replaced by the corresponding value in the Partition By column.
After specifying the details for partition, continue from STEP 5 IN CASE 1. The result is shown in figure below:
The result shows a list of files corresponding to each TARGETDATE_. The open text file shows the file corresponding to one target date with ","(comma) separated data.