excel import in business central | business central development tutorial | excel buffer | trending

Hi Viewers,
excel import in business central | business central development tutorial | excel buffer | trending
This channel is dedicated to research aspirants and all who wish to learn technologies with easy examples and exercises. I will be uploading at least three videos every week. You can leave the expected topics that you wish to know in the comment.
‪@Microsoft‬ ‪@MicrosoftDynamics365BC‬
Checkout your favorite playlist
==================================================================================
Important tutorials and videos (Playlist) that you should not miss
==================================================================================
1. Research: • PhD Course details, Ph...
2. SCI/Scopus/Annexure-I/WoS/UGC care indexed journals
• SCI, Scopus, Annexure-...
3. Weka Tutorial:
• Weka Tutorial
4. Tableau Prep Builder: • What is Tableau Prep |...
5. ETL Data Integration: Talend:
• What is ETL? well Expl...
6. AL Programming - Microsoft Dynamics 365 Business Central (AL Programming): • AL Programming for abs...
7. Web Designing for Kids:
• Simple sign-in form in...
8. Tableau Desktop: • Learn Tableau Basic Ca...
9. Python Interview Questions: • What is Negative index...
10. GraphPad Prism Statistical Tool: • Introduction to GraphP...
11. R and Rattle GUI for statistics and Research: • Introduction to R and ...
12. Minitab Statistical Tool: • How to download, insta...
13. Online teaching tool for teachers, professors and online mentors: • Best online Whiteboard...
14. Skill-up yourself: • How to become a google...
======================================================================
Social media:
Blog: draft.blogger....
GitHub: github.com/Gom...
LinkedIn profile: / gomathisri
Instagram profile: @goms_tech_talks
Facebook profile: / goms.techtalks
Website: sites.google.c...
======================================================================
Happy learning

[@NiteshEtech]

Thank you for informative session.please make an video on json consumption in business central

[@gomstechtalks]

Sure

[@mothercensured]

Hello Gomathi! What I really liked about this video is that you wrote the code line by line explaining each step. This makes the video duration longer but I get the feeling I learn better this way instead of copying&pasting the code from your GitHub. Thanks for your efforts!

[@gomstechtalks]

Thank you so much for your valuable feedback. I will follow this type of explaining the concepts from the upcoming videos. 🤗🤗🤗🎉🎉🙏🙏

[@akkaradechsrithongchai7766]

Thank you so much .

[@gomstechtalks]

Welcome.

[@shivasai7131]

Nice video Before I don't know This concept but but after i see this video this is very useful for me and can you explain the matrix page also

[@gomstechtalks]

Sure. Thank you

[@mukeshkumawatcool]

i tried Task and it also completed thank you mam

[@gomstechtalks]

Great to hear. Thank you.

[@mukeshkumawatcool]

Thank you Mam

[@gomstechtalks]

Welcome.

[@NilamBhor13]

Hi, I write a logic i. e. Using excel buffer my header column names will be repeated or iterated. Like below example; Quantity Value Quantity Value Quantity value. Can you please give me the idea

[@gomstechtalks]

Hi, I haven't experienced this personally, but try the below steps To achieve the repeated or iterated header column names in your Excel report, you can follow these steps: 1. First, make sure you have set up your Excel buffer properly to handle data export. 2. Next, you'll need to design your report layout. In the report's dataset, you can define variables to hold the header column names (e.g., Quantity, Value, Quantity, Value, Quantity, Value). 3. In the report's data item, you can write a codeunit or function that populates these variables with the appropriate column names in the desired sequence. 4. When exporting data to the Excel buffer, ensure that you add these variables as part of the data output, so they appear in the first row of your Excel sheet.

[@alvaropm909]

Hello! Can I make an action that connects with a codeunit and it has all that code inside? Would it work too?

[@gomstechtalks]

Yes. Possible.

[@miteshwar78]

Hi Goms. Wanted to connect with you regarding BCE implementation. Let me know the best way to connect.

[@manishgoyal4804]

How to bold and italic excel export file headers.

[@gomstechtalks]

Usual formatting options. Once you created the report, you can do that.

[@NilamBhor13]

Hi, I want write a condition on excel report using excel buffer. My report has amount column, & this column come from customer ledger entry table. If my amount is 0 then display no balance text in column. Can you give me idea, how to do this

[@gomstechtalks]

Hi there! To display 'no balance' text in the amount column of your Excel report based on the customer ledger entry table, you can use an IF statement in Excel. Here's an idea on how to approach it: 1. Open your Excel report and locate the column where you want to display the 'no balance' text. 2. In the cell where you want the text to appear, enter the following formula: =IF(CustomerLedgerEntryTable!Amount = 0, "No balance", CustomerLedgerEntryTable!Amount) Note: Replace 'CustomerLedgerEntryTable' with the actual name of your table and 'Amount' with the corresponding column name. 3. This formula checks if the amount in the customer ledger entry table is equal to 0. If it is, it displays 'No balance'; otherwise, it shows the actual amount. 4. Drag the formula down to apply it to all the rows in the column, and the 'no balance' text will appear whenever the amount is 0. Remember to adjust the table and column names to match your specific scenario. I hope this helps! Regards, Dr. Gomathi S

[@venkannababu-s6l]

Hi Mam, i have one query related to Merging of 2 or more columns(eg: A and B) cells in excel template into 1 single cell. I'm using excel buffer to export the data from Business central Saas 24.2 IN version. so i want to merge 2 or more cells in excel to show the captions. Is there any way to merge the column cells. please guide me.

[@gomstechtalks]

Please try this ExcelBuffer.NewRow(); ExcelBuffer.AddColumn('Caption for Merged Cells', false, '', true, false, false, '', ExcelBuffer."Cell Type"::Text); ExcelBuffer.AddColumn('', false, '', false, false, false, '', ExcelBuffer."Cell Type"::Text); ExcelBuffer."Merge Cells" := 'A1:B1';

[@venkannababu-s6l]

@@gomstechtalks Thanks mam for your quick response, I just verified, that Merge cells field or procedure not available in BC SaaS 24.2 IN version Excel Buffer table. Any alternative for BC SaaS IN version.

[@gomstechtalks]

@user-hk6qr2un1m I am using a different version. Let me check for any other possibilities and update you.

[@venkannababu-s6l]

@@gomstechtalks Thank you, Please.