Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Create an Excel file f...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Create an Excel file from store commerce client

(0) ShareShare
ReportReport
Posted on by Pankaj_93 392

Hello All,

Hope all are doing well !!!

We have a requirement to display transaction data in the commerce app UI and on the app bar button click it should save the same data into a excel file of the pos machine.

We are able to achieve to display the data in the front end. Unfortunately, we are not able to create an excel file and save the file in the local pos machine.

Could you please assist us how we can achieve this?

Thank you in Advance...

  • Pankaj_93 Profile Picture
    Pankaj_93 392 on at
    Create an Excel file from store commerce client
     
    I have installed the npm package for the exceljs in the library folder. It downloaded all the files that are dependencies for exceljs. Shall I configure the exceljs.d.ts file only in the manifest and tsconfig file and the same in the csproj file? Could you please guide me here?
     
    Thanks in Advance...
  • Suhail Ismail Profile Picture
    Suhail Ismail 103 on at
    Create an Excel file from store commerce client
    If you want to use excel js then you can add the library similar to how knockout is being added, and also add the type file to the project so that you can access it from ts files.
  • Pankaj_93 Profile Picture
    Pankaj_93 392 on at
    Create an Excel file from store commerce client
    Hi Shafeeque,
     
    Thank you for your response. Basically we are trying to do it typescript. As I googled and found that there is a plug in as ExcelJs to write the data to excel. Here I am not able to understand how to configure the excel js in tsconfig.json file.
     
    Thanks in Advance...
  • Shafeeque P. Profile Picture
    Shafeeque P. 6,487 Super User 2024 Season 2 on at
    Create an Excel file from store commerce client
    By third-party plugin, I was referring to a nuget package that can be included in your development project.
  • Suggested answer
    Shafeeque P. Profile Picture
    Shafeeque P. 6,487 Super User 2024 Season 2 on at
    Create an Excel file from store commerce client
    I am not a developer. But this can be achieved using third-party plugins. We exported a file to . CSV format.  One restriction I recall was that you can only save the file to the user's download folder.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans