Hi everyone,
i tried Predefined MS Excel VBo to write collection in to Excel but i have 3000 Records it is taking long time to write collection in to Excel , i was trying any other better approach to fix my problem so i want to give a try by Writing C# Code
i Was Aware How to Write code From Collection to Excel but my Question is in c# we used an extension to write datatable to excel how can i use these extensions in iBlue Prism? Is there any Way i can get these extensions and use in blue prism?
?
and als0 these Variables Where can i add These Variables in Code Stage or information at start of the object?
i tried Predefined MS Excel VBo to write collection in to Excel but i have 3000 Records it is taking long time to write collection in to Excel , i was trying any other better approach to fix my problem so i want to give a try by Writing C# Code
i Was Aware How to Write code From Collection to Excel but my Question is in c# we used an extension to write datatable to excel how can i use these extensions in iBlue Prism? Is there any Way i can get these extensions and use in blue prism?
- Microsoft.Office.Interop.Access.Dao
- Microsoft.Office.Interop.Excel;
- Microsoft.Office.Interop.Graph
?
and als0 these Variables Where can i add These Variables in Code Stage or information at start of the object?
- Microsoft.Office.Interop.Excel.Application excel;
- Microsoft.Office.Interop.Excel.Workbook excelworkBook;
- Microsoft.Office.Interop.Excel.Worksheet excelSheet;
- Microsoft.Office.Interop.Excel.Range excelCellrange;