I have an issue on Excel usage.
In my scenario I have to export from a desktop application a set of data in Excel file.
By default, Excel opens Book1.xlsx workbook that I have to save it on the disk for a future operation.
How it will be possible to determine when the export is finished?
After clicking export I’ve attached the Excel window using Attach Window activity, but I don’t know how
to check if the entire set of data was loaded.
@Mugur, Use Excel Application scope
Cannot use Excel Application Scope on an unsaved file.
You can check Row count .
I’m exporting some data in excel and I don’t know how many rows will be exported. How to check row count?
You will be having a Datatable Right? . You can get the Count by using log or MessageBox
with value Datatable.Rows.Count.ToString
I don’t have a data table because I cannot read the excel. I want to save the excel after loading it. But I need to know when the entire file is loaded
Can you please share the Xaml, it would be helpful for us to understand better