429d6b08-7b09-406b-bb91-aa8e87e9fb8a.png

Supercharge your Excel workflows by unlocking the power of automation! 

Experience optimized data processing by automating tasks such as filtering, sorting, merging, and aggregating data. Save valuab

Data Automation in Excel

自動化の力を解き放ち、Excel ワークフローを強化しましょう。

データのフィルタリング、並べ替え、結合、集計などのタスクを自動化することで、最適化されたデータ処理を体験してください。貴重な時間を節約し、生産性を向上させ、完璧なデータ精度を簡単に確保します。

ファイル変換を簡単に合理化し、面倒な手動変換に別れを告げます。データを関係者とシームレスに共有し、好みのシステムやアプリケーションに統合

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

021e0047-af37-4049-bce0-74719ddf7ba0.jpg

RPA Developer

911259ed-5fee-4b68-a009-c95de09a1f65.nupkg

**Objectives:**

*   Providing a robust and facile manner of processing very large Excel files in the background and without relying on COM Interop.
*   The implementation of these custom activities will give the user the last row of the Excel file (extremely useful when trying to process a file in chunks). Currently trying to read a file in chunks is impossible without knowing the number of rows and columns in the sheet.
*   The implementation of an Application Scope activity that will allow the grouping of the custom activities in this package.
*   Providing activities that are similar in structure and type of parameters to the current Excel application.

**Observation and limitations:**

  
The activity will not keep track of the formats used to display values in the Excel application. For example, a cell with a value of 43006 formatted as date will be displayed as 9/28/2017 in Excel, but this activity will still retrieve it as 43006.  

Files in which the row starts with the index 0 (this index can be found in the XML mark-up of the row) will not be processed. The row number also needs to be under 1048576 (the maximum number of rows in an Excel Sheet). If a row number outside of this interval is found, the application will throw an exception. This limitation is also valid for the Read Range in the Workbook activities package.  

This package is not compatible with .xls files or .csv files. Only .xlsx files can be read with this activity. Reading Large XLS files can be done in conjunction with the Conversions Package, which will convert the file to an .xlsx file, thus making it compatible with this package.  

Some very minor differences when deciding where a range ends between the standard Excel processing activities and this one.

  

**Technical Approach:**  

The files will be processed in the background using the Open XML SDK library and the SAX (Simple API for XML) approach which instead of reading the entire document and exposing its DOM, will independently read the XML files that comprise the Excel document.

  

**Read Range**

  

**Principles**

  

This custom activity reads a Range of cells from an Excel Sheet. It achieves its goal by using the Open XML SDK framework and the OpenXmlReader class to parse the File in a SAX like approach. To get the number of rows, we simply parse the file and count the rows.  

The custom activity is created by simply inheriting the CodeActivity class from the Windows Workflow Foundation framework. We define the logic of the function by implementing the Execute method and we define the input and output of the activity by fields of the InArgument and OutArgument types.  

This activity can only be placed inside a XL Excel Application Scope activity (not necessarily directly inside, but one of its parents must be the XL Excel Application Scope).

An activity pack used to read and process extra large Excel files.

Version	Release Date	Download Link
1.0.68	September 13, 2018
First Release

Read Extra Large SpreadSheets