Excel as Source

[Alfredo YM]

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

 

[ArshilAhmad]

Hi @Alfredo YM,

1.- How couls I force to import allrows ?

The "Microsoft Excel: New Row in a Worksheet" trigger only captures the last row added to your worksheet, so importing the entire data of an existing worksheet is not possible.

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

Please check out the thread attached below:

Excel can not fine macro enabled workbook??

Is there a limitation to pabbly that it can not connect to a macro enabled excel file??

forum.pabbly.com

 

[Alfredo YM]

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 ) ?

 

[ArshilAhmad]

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

No, 8 hours is just the polling time. You can add data to multiple rows; each row will be treated as a separate task, and your workflow will be triggered for each newly added row.

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

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

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 ) ?

No, the data has to be added to the last row of your worksheet.

 

[Alfredo YM]

Hi,

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

I copied the last row and paste in next row, but no effects.

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

 

[Pabblymember11]

Hey @Alfredo YM

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

 

[Alfredo YM]

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.

 

[Pabblymember11]

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

 

[Alfredo YM]

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

Now it looks that copy&paste in the last row is working.

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

Thanks

 

[Pabblymember11]

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?