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
We already have at least six threads about the same thing. Starting the discussion again and again from scratch makes no sense.
Hi Harry,
I update Excel cells before calling data entity to import data
Regards,
Waed
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.
Hi Harry,
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
Regards,
Waed
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.
Modify I want to modify just one cell in Excel.
Regards,
Waed
Modify or insert into D365FO?
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
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.
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156