How to check if excel file was loaded?

Help
,
1

Hi guys
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.
Any ideas?
Thanks

2

@Mugur, Use Excel Application scope

3

Cannot use Excel Application Scope on an unsaved file.

4

You can check Row count .

5

I’m exporting some data in excel and I don’t know how many rows will be exported. How to check row count?

6

You will be having a Datatable Right? . You can get the Count by using log or MessageBox
with value Datatable.Rows.Count.ToString

7

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

8

Can you please share the Xaml, it would be helpful for us to understand better

9

Did u get the solution for this kind of case?

10

Hi Visky,
I’m sorry, but after 5 years I don’t remember if my issue was solved or not. I don’t remember which is the flow that I have to check, because we have more than 200 now.
Have a nice day!
Mugur