Encodian - Excel

The file content of the source CSV file

Set the CSV delimiter, the default value is a comma: ','

Manually set the column headers for the CSV data (Column delimited: Column 1, Column 2, etc.

Skip the first line of the CSV file, set to 'Yes' if your CSV document contains column headers

The file content of the source Microsoft Excel file

The file content of the image to insert

The position to add the image to within the Microsoft Excel file provided

A comma separated list of the names of the worksheets to add the image to: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to add the image to: 1,3,4

Set the top margin value (cm). Default is 1.9cm

Set the bottom margin value (cm). Default is 1.9cm

Set the right margin value (cm). Default is 1.9cm

Set the left margin value (cm). Default is 1.9cm

Change the thread culture used to process the request

The file content of the source Microsoft Excel file

The JSON dataset to be processed and added as rows to the Excel file provided

The row number after which the data provided will be inserted

The column number after which the data provided will be inserted

Specify the name of a specific worksheet

Auto parse numeric and date values, setting the cell format category to 'Number' or 'Date'

Set the date and time format - https://video2.skills-academy.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Set the numeric format - https://video2.skills-academy.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings

Ignores titles of JSON attributes when converting JSON to Excel

Ignore JSON properties which contain null values.

Change the thread culture used to process the request.

The file content of the source Microsoft Excel file

The text to add to the 'Left Header' position

The text to add to the 'Central Header' position

The text to add to the 'Right Header' position

The text to add to the 'Left Footer' position

The text to add to the 'Central Footer' position

The text to add to the 'Right Footer' position

A comma separated list of the names of the worksheets to add the text to: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to add the text to: 1,3,4

Change the thread culture used to process the request.

The file content of the source Microsoft Excel file

The text to embed as a watermark within the Microsoft Excel file

Set the numeric row that the watermark should be inserted from

Set the numeric column that the watermark should be inserted from

Set the height of the container which contains the watermark text (in pixels)

Set the width of the container which contains the watermark text (in pixels)

Set the font type applied to the text watermark, the default font is set to Calibri

Set the HTML colour applied to the text watermark, the default colour is set to #808080 (Grey)

Set whether to apply the 'Italic' format to the text

Set whether to apply the 'Bold' format to the text

The opacity of the text watermark, valid values range from 0 to 1 (Hidden), the default value is 0.7

Set the rotation angle of the watermark in degrees

A comma separated list of the names of the worksheets to add the watermark to: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to add the watermark to: 1,3,4

Override and manually set an identifier for the applied watermark

Change the thread culture used to process the request.

The file content of the source Excel file

Set the number of the first row to delete

Set the number of the last row to delete

Set the name of a specific worksheet to delete the rows from

Set an array of rows to delete, conforming to following structure: [23-56],[100-120],[156-8988]

The file content of the source Microsoft Excel file

A comma separated list of the names of the worksheets to extract: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to extract: 1,3,4

The file content of the source file

Set the name of a specific worksheet to be exported

Set whether the first row specified is a header row

Set the number of the first row to be exported

Set the number of the last row to be rows to be exported

Set the number of the first column to be exported

Set the number of the last column to be exported

Set whether empty rows should be excluded from the export

Set whether empty cells should be exported

Set whether values should be exported as text, i.e. a number would be exported as "value":"3"

Set how Hyperlinks should be exported

Force row data to be exported as a JsonObject even when there is only a single worksheet contained within the file

Set the thread culture used to process the request

The file content of the source Microsoft Excel file

A comma separated list of the names of the worksheets to extract: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to extract: 1,3,4

The filename of the output excel file

The format of the output excel file

The filename of the source file, the file extension is mandatory: 'file.xlsx' and not 'file'

The file content of the source file

Set the sort position within the document array

Specify which worksheets from the source file should be included within the output

The filename of the output excel file

The format of the output excel file

The filename of the source file, the file extension is mandatory: 'file.xlsx' and not 'file'

The file content of the source file

Set the sort position for the document within the array, lowest number first

Specify which worksheets from the source file should be included within the output

Set whether to include the first row of the worksheet

Assure that the first row of the first workbook and sheet is always preserved

The Microsoft Excel workbook (XLSX) to populate

The JSON data to populate the Microsoft Excel wookbook with

Sets the JSON parsing mode for simple values (null, boolean, number, integer, and string)

Automatically calculate formulas upon population

When enabled data is added to the workbook using corresponding Excel data types as opposed to a string data type

Sets the engine to allow missing values within the 'JSON Data'

Produces errors within the resultant workbook as opposed to rejecting the request with a HTTP 4** error

Sets the engine to automatically removes any empty paragraphs upon execution

Set one or more specfic formats for parsing DateTime values

Change the thread culture used to process the request

The file content of the source Microsoft Excel file

Set whether to remove the header from left position

Set whether to remove the header from central position

Set whether to remove the header from right position

Set whether to remove the footer from left position

Set whether to remove the footer from central position

Set whether to remove the footer from right position

A comma separated list of the names of the worksheets to remove the header/footer from: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to remove the header/footer from: 1,3,4

Change the thread culture used to process the request

The file content of the source Microsoft Excel file

The watermark identifier of the watermark to remove, as provided by the Encodian 'Excel - Add Text Watermark' action

A comma separated list of the names of the worksheets to remove the watermark from: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to remove the watermark from: 1,3,4

Change the thread culture used to process the request.

The file content of the source Microsoft Excel file

Set the password used to open the Microsoft Excel file

Set the protection type to apply to the Excel Workbook

Set the password used to protect the Excel Workbook

Set the protection type to apply to the Excel worksheets

Set the password used to protect the specified Excel worksheets (All by default)

A comma separated list of the names of the worksheets to protect: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to protect: 1,3,4

Change the thread culture used to process the request.

The file content of the source Microsoft Excel file

Set the password used to open the Microsoft Excel file

Set the password used to remove protection from the Excel Workbook

Set the password used to remove protection from the specified Excel worksheets (All by default)

A comma separated list of the names of the worksheets to remove protection from: Sales, Totals, Year to Date

A comma separated list of indexes of the worksheets to remove protection from: 1,3,4

Change the thread culture used to process the request.

A Base64 encoded representation of the Excel file to be processed

The JSON dataset to be processed and added as rows to the Excel file provided

The row number which the data provided will start updating from

The column number which the data provided will start updating from

Set the name of a specific worksheet to be updated

Auto parse numeric and date values, setting the cell format category to 'Number' or 'Date'

Set the date and time format - https://video2.skills-academy.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Set the numeric format - https://video2.skills-academy.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings

Ignores titles of JSON attributes when converting JSON to Excel

Ignore JSON properties which contain null values.

Set the thread culture used to process the request