Announcements
No record found.
Hi All,
I have an excel file with data that I imported using an upload file, and I want to change the value of a datetime cell.How do I do this through X++ code?
Regards,
Waed
You can try something like below
str2Date((range.get_Item(i, 2).value),123);
Also can you share an example of source data and what is expected in target.
Hi Harry,
I want to modify value of datetime cell using this value 1/12/2023 9:46:29 PM for example I am reading value from datetime field in table in Dynamics 365 FO
Modify or insert into D365FO?
Modify I want to modify just one cell in Excel.
Sorry but now its confusing.
What exactly you are trying to do,
Importing excel into FO Or Exporting data from FO,
Why you want to modify excel from x++ code.
I have an Excel file I want to upload using file upload, While I am uploading it I want to fill cell "its type datetime" then I want to call data entity to import the updated excel file using data entity
Ok, so you got an excel and first wanted to correct some data into the excel using code and than import this updated excel into FO using data entity.
If my understanding is correct, you can write your code into data entity and manipulate excel cell value before importing.
I update Excel cells before calling data entity to import data
We already have at least six threads about the same thing. Starting the discussion again and again from scratch makes no sense.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 577 Super User 2026 Season 1
Giorgio Bonacorsi 309
Diego Mancassola 259