Export To Text

Export to Text 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) Ribbon

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. Data

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:$I$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: Data

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

Step 4

If the data need 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. Data

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

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 column to be exported should be checked. Data

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. Data

Step 7

After specifying the columns, select the location of the file or folder(in case of multiple files) into which data need to be exported by hitting on the browse button under Destination. Data

Step 8

After entering all the specifications click Next. Data

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. Data

Step 9

After entering your choice, click Finish. Data

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 should be exported to multiple text files based on the value in a particular column, check Partition the data box. Data

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

Step 5

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

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. Data

Step 7

After specifying the details for partition, continue from step 5 in Case 1. The result is shown in figure below: Data

The result shows a list of files corresponding to each Company. The open text file shows the file corresponding to one company with ","(comma) separated data.