• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

generalExeption with Microsoft Excel

Hello,

i have an issue to send data to Excel.
I get an general Exception ... from this error I cannot see what i need to change.
I can select the right excel sheet and the right worksheet ... assign the fields but writing the data does not work.

any idea how I can dig deeper ?

The step after the excel runs without problem

THX and best wishes

Niels
 

Attachments

  • Monosnap Pabbly Connect 2023-08-30 11-04-54.jpg
    Monosnap Pabbly Connect 2023-08-30 11-04-54.jpg
    662.7 KB · Views: 64

Chetali

Administrator
Staff member
Hey @niels.przybilla!

We reviewed your workflow and identified that in the "Add Row To Worksheet" action step there are double quotes in the "Column G (Res3 Field Data)" value which is causing problems.

1693468455198.png


To address this, we have implemented a workaround by adding the "Text Formatter by Pabbly: Replace Text" step. This step replaces double quotes with single quotes. The resulting output from this step is then mapped to the "Column G (Res3 Field Data)" field. As a result of this, the "Add Row To Worksheet" action is now functioning correctly, without any errors.

1693468610765.png
 
Hello @Chetali ,

great ! Thank you very much for the help. So in general it would be better to not import such fields with double quotes into Excel ?

(If i do not want to use the reformater) ?

THX and best wishes

Niels
 

Supreme

Well-known member
Staff member
Yes, kindly try using single quotes instead of double quotes for every incoming quote data!
 
Top