cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

Create Excel Workbook - Export without column headers

Trying to import data from Excel workbooks, manipulate and update the data, and then save the workbook again in Excel.  However, since the option doesn't exist, the exported data must include the Column Headers on each of the Excel sheets.

 

The functionality already exists for exporting .txt files to exclude column headers.  I'd like to see this expand into the Create Excel Workbook function or Export tool.

 

 

2 Comments
Raaed
Level IV

first part

 

 

// Import Excel file: num data.xlsx
// → Data Table( "Sheet1" )
Open(
    "/D:/students/لمى/num data.xlsx",
    Worksheets( "Sheet1" ),
    Use for all sheets( 1 ),
    Concatenate Worksheets( 0 ),
    Create Concatenation Column( 0 ),
    Worksheet Settings(
        1,
        Has Column Headers( 1 ),
        Number of Rows in Headers( 1 ),
        Headers Start on Row( 1 ),
        Data Starts on Row( 2 ),
        Data Starts on Column( 1 ),
        Data Ends on Row( 0 ),
        Data Ends on Column( 0 ),
        Replicated Spanned Rows( 1 ),
        Replicated Spanned Headers( 0 ),
        Suppress Hidden Rows( 1 ),
        Suppress Hidden Columns( 1 ),
        Suppress Empty Columns( 1 ),
        Treat as Hierarchy( 0 ),
        Multiple Series Stack( 0 ),
        Import Cell Colors( 0 ),
        Limit Column Detect( 0 ),
        Column Separator String( "-" )
    )
);

// Close Data Table: Sheet1 2
Close( Data Table( "Sheet1 2" ), NoSave );

 

Raaed
Level IV

second part

/*:

// Import Excel file: num data.xlsx
// → Data Table( "Sheet1" )
Open(
"/D:/students/لمى/num data.xlsx",
Worksheets( "Sheet1" ),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers( 0 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 1 ),
Data Starts on Row( 1 ),
Data Starts on Column( 1 ),
Data Ends on Row( 0 ),
Data Ends on Column( 0 ),
Replicated Spanned Rows( 1 ),
Replicated Spanned Headers( 0 ),
Suppress Hidden Rows( 1 ),
Suppress Hidden Columns( 1 ),
Suppress Empty Columns( 1 ),
Treat as Hierarchy( 1 ),
Multiple Series Stack( 0 ),
Import Cell Colors( 0 ),
Limit Column Detect( 0 ),
Column Separator String( "-" )
)
);