# Excel **URL:** https://forum.robusta.ai/c/faq/excel/60.md [Latest](https://forum.robusta.ai/latest.md) · [Categories](https://forum.robusta.ai/categories.md) · [Tags](https://forum.robusta.ai/tags.md) --- ## [About the Excel category](https://forum.robusta.ai/t/about-the-excel-category/527)
**Author:** [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\ **Replies:** 0
--- ## [İki̇ farkli excel datasinda düşeyara kullanimi](https://forum.robusta.ai/t/iki-farkli-excel-datasinda-duseyara-kullanimi/662)
**Author:** [@cihanmzrk](https://forum.robusta.ai/u/cihanmzrk)\ **Replies:** 0\ **Last updated:** [June 25, 2025, 11:11am UTC](https://forum.robusta.ai/t/iki-farkli-excel-datasinda-duseyara-kullanimi/662 "2025-06-25T11:11:27Z")
Merhaba, elimde iki Excel dosyası bulunmakta: biri “ana data”, diğeri ise “matcher” dosyası. Amacım, ana datadaki örneğin A sütunundaki hücreleri, matcher dosyasındaki hücrelerle karşılaştırmak. Eğer eşleşme varsa, ana d… --- ## [Excel çift şartlı sortlama koyma](https://forum.robusta.ai/t/excel-cift-sartli-sortlama-koyma/627)
**Author:** [@ogulcankabas](https://forum.robusta.ai/u/ogulcankabas)\ **Replies:** 2\ **Last updated:** [May 13, 2024, 12:47pm UTC](https://forum.robusta.ai/t/excel-cift-sartli-sortlama-koyma/627 "2024-05-13T12:47:51Z")
Merhaba, Robusta’da 2 kez sortlama koyabilme şansım var mı ? Örneğin elimde filtresiz karışık verilere göre excel olsun. Bu verileri A sütununa göre filtreleyip sonrasında 1. sortlama işlemini A sütununda asc olarak… --- ## [Excel Cell Control](https://forum.robusta.ai/t/excel-cell-control/455)
**Author:** [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\ **Replies:** 0\ **Last updated:** [November 16, 2022, 12:29pm UTC](https://forum.robusta.ai/t/excel-cell-control/455 "2022-11-16T12:29:14Z")
In order to paint the columns of the Excel columns in the desired format with red color, type the Regex that you wrote the rules for in the Script Task activity. Assign a variable to “true” or “false” to provide control. … --- ## [Convert HTML File to Excel](https://forum.robusta.ai/t/convert-html-file-to-excel/456)
**Author:** [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\ **Replies:** 0\ **Last updated:** [November 16, 2022, 12:43pm UTC](https://forum.robusta.ai/t/convert-html-file-to-excel/456 "2022-11-16T12:43:09Z")
If you want to Convert HTML File to Excel and open Excel, you can convert HTML file to Excel if you run the code block below with Run CMD. "$xlSLSXType = 51 ; $xl = New-Object -ComObject Excel.Application; $xl.Visible… --- ## [Exporting a Pivot Table to a Different Excel](https://forum.robusta.ai/t/exporting-a-pivot-table-to-a-different-excel/462)
**Author:** [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\ **Replies:** 0\ **Last updated:** [November 16, 2022, 2:19pm UTC](https://forum.robusta.ai/t/exporting-a-pivot-table-to-a-different-excel/462 "2022-11-16T14:19:21Z")
You can copy the pivoted table to a different excel by following the steps below; 1- After the pivoted excel is saved and closed, the below mentioned vba is run with the call vb script activity. The pivoted table with t… --- ## [Loops Operations in Excel Rows](https://forum.robusta.ai/t/loops-operations-in-excel-rows/465)
**Author:** [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\ **Replies:** 0\ **Last updated:** [November 16, 2022, 2:50pm UTC](https://forum.robusta.ai/t/loops-operations-in-excel-rows/465 "2022-11-16T14:50:40Z")
To create a virtual copy of the Excel file (table), the Excel file related to the Open activity is opened from the Excel activities. Then, using the “Read excel to dataset” activity, the relevant page of the excel file o… --- ## [Opening Excel file on the front side](https://forum.robusta.ai/t/opening-excel-file-on-the-front-side/471)
**Author:** [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\ **Replies:** 0\ **Last updated:** [November 17, 2022, 7:37am UTC](https://forum.robusta.ai/t/opening-excel-file-on-the-front-side/471 "2022-11-17T07:37:52Z")
If you want to open an Excel file on the frontend, you can find its exe and run it from CMD to run Excel. In this way, the front side will be opened. You need to connect the Excel operations with Application Open, then y…