Excel as Source

Hi

It is my first workflow, my necesity is export to MySql from Excel.

For this I made a workflow, the origin app is excel and the triger is New Row in Whorksheet.

But I have few rows in the worksheet previuos to the first import.

I cut all the rows, saved and closed the excel, open again and paste all the rows.

Also I placed a new row in the sheet.

After first Task, only one row was transfered, the last that I place manually.

1.- How couls I force to import allrows ?
2.- Normally the rows of this excel worksheet will be inserted by a vba macro ( automatically ), will this triger the workflow task ?

Thank you

Hi @Alfredo YM,

1.- How couls I force to import allrows ?

2.- Normally the rows of this excel worksheet will be inserted by a vba macro ( automatically ), will this triger the workflow task ?

Hi @ArshilAhmad

Thanks,

The "Microsoft Excel: New Row in a Worksheet" trigger only captures the last row added to your worksheet.

1. Does it means that if several rows are added during the last 8 hours, the trigger only will capture lastone ?

Undestand that the trigger in not "capturing" the rows that i'm adding by copy&paste, even in the lastone.

2. Is there any chance for trigger recognize it ?, ( pasting by insert or anyother way )
3. will trigger recognize if the macho insert a new row in the middel ( will be last added, but not the last in the excel worksheet ) ?

1. Does it means that if several rows are added during the last 8 hours, the trigger only will capture lastone ?

Undestand that the trigger in not "capturing" the rows that i'm adding by copy&paste, even in the lastone.

3. will trigger recognize if the macho insert a new row in the middel ( will be last added, but not the last in the excel worksheet ) ?

Hi,

Could you please add the data by copy-pasting it to the last row of your worksheet once more?

Also I ran this code in vba,

For a = 2 To 50
For b = 1 To 26
Cells(a + 50, b) = Cells(a, b)
Next b
Next a

Filling 49 Rows with the data from the rows 2-50,

This also doesn't trigger the workflows.

Also 8h waiting the process doesn't help to solve.

Thanks

Hey @Alfredo YM

Can you please record a short video on how you are trying to add a new row from your Excel file?

Can you please record a short video on how you are trying to add a new row from your Excel file?

Simple copy&paste. The server doesn't allow upload the video.

Kindly upload it to Google Drive and share the link with us.

Kindly upload it to Google Drive and share the link with us.

But i does'nt work when is filled from a macro.

Thanks

Can you please record a short video on share it with us on Google Drive link how you are passing the macros in an MS Excel sheet?