Export To Text


This function is used to export data into text file(s).

SheetKraft contains the Export to Text option which can be accessed by the Export Button present in the SheetKraft Toolbar (See figure)

exporttotext


Case 1: Basic Example:

The following guidelines describe how Export to Text is used.

Step 1:

Click on the Export Button and select the Export to Text option to open this dialogue box

exporttotext

Step 2:

Select the data that needs to be exported. There are two ways by which you can select the data:

  1. By manually selecting the data from the sheet.
  2. 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.

Step 3:

The dialogue box shown below, opens

exporttotext

Check the File has headers box if the data headers need to be copied to the text file.

exporttotext

Step 4:

If the data needs to be exported to multiple text files, check Partition the data box and follow the steps in CASE 2.

Step 5:

Select the delimiter to be used from the Delimiter drop-down window. By default the delimiter will be Comma.

exporttotext

User might want to consider certain values in the data as a BLANK field. The value can be provided in the field provided.

exporttotext

Also, if a user wants to Add certain data in an existing file. Click on Append to the file in the field provided.

exporttotext

Step 6:

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.

exporttotext

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.

exporttotext

For each column we can use Export Condition. Export Condition allows the user to specify a condition for each column.

exporttotext

Step 7:

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.

exporttotext

Step 8:

After entering all the specifications click Next.

exporttotext

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.

exporttotext

Step 9:

After entering your choice, click Finish

exporttotext

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.

Step 4:

For the data to be exported to multiple text files based on the value in a particular column, check Partition the data box.

exporttotext

Then two new fields appear: Partition By and Into Files.

exporttotext

Step 5:

Partition By drop-down contains the name of all the data columns. Select the column based on which data needs to be partitioned.

exporttotext

Step 6:

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.

exporttotext

Step 7:

After specifying the details for partition, continue from STEP 5 IN CASE 1. The result is shown in figure below:

exporttotext

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.