export to excel in business central | Excel buffer | business central tutorial

[@rajaneeshraj5724]

Hi Madam, how can we make file saved in a predefined folder? Is there any way and also can we make a job queue to run when needed? Thanks in advance

[@gomstechtalks]

It should be possible. Let try and tell you.

[@SmileyQueenGirl]

Hi mam, how to set row as bold format, and background color in excel buffer in excel report.

[@gomstechtalks]

We can use font formatting and background options in excel

[@madhavadhatrao3528]

Hi Mam, i have write Excel buffer for sales Header and sales line . SH exported successfully but Sales line not showing data. what to do in this case

[@gomstechtalks]

Then there is no data. Add the data and try it again please.

[@madhavadhatrao3528]

@@gomstechtalks Data is present mam in line

[@gomstechtalks]

Please check whether the formatting is correct, and also check whether you have correctly written the code for the sales line.

[@gomstechtalks]

Run the debugger and check the issue

[@madhavadhatrao3528]

@@gomstechtalks i have put setrange and issue has solve. Thank you

[@prafulsingh6463]

Hi ma'am please make more video to import xml file in Business central

[@gomstechtalks]

Sure Praful.

[@stefanolorini2565]

hi, can i add a formula that control if i divide by zero and don't give me errors? thx

[@gomstechtalks]

You can add this in the trigger

[@dividutt]

How to get sum of data in column in Excel report.

[@gomstechtalks]

You can use excel functions in the report.

[@dividutt]

@@gomstechtalks But when I used Excel function Sum in Total section it is giving zero.

[@UdoLauer]

I cannot find the record "Excel buffer" on github.

[@gomstechtalks]

Sorry, I will update it soom

[@UdoLauer]

I found it in the Symbols. I forgot to download them first