unable to generate json from excel

Question

hii,

I am working on Income tax Excel utility (macros enabled) but I am unable to generate json file from it.

It is showing your json is saved at https://d.doc......

Answer 1

Hello, Sonam Kazmi.

Thanks for reaching out to our Microsoft Community Forum. Please accept our sincerest hope that all is well.

We understand you are unable to generate JSON from an Excel file.

This issue may have been caused by settings in Windows or Excel that need to be changed. So, let us work together as a team to get to the bottom of this. But to better assist you I need to ask:

1. What version of Office are you using? Microsoft 365 Personal? Microsoft 365 Family? Microsoft 365 Business Standard? Microsoft 365 Apps for Enterprise? Office 2016? Office 2019? Office 2021? I specifically need the Product name and Version number as highlighted in the guide and photo below.

https://support.microsoft.com/en-us/office/about-office-what-version-of-office-am-i-using-932788b8-a3ce-44bf-bb09-e334518b8b19

2. What version of Windows are you using? We specifically need the edition and version number of Windows your device is running. To find out which version of Windows your device is running, press the Windows logo key + R, type winver in the Open box, and then select OK. You'll get the window below and we need the information highlighted in red.

3. How long have you had this issue? An exact date of when this issue occurred could prove helpful. If not possible an estimate in days, weeks or months will be fine too.
4. Have you tried to repair Office using the steps in the link below and see if that fixes the issue?

https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

5. Have you tried to reinstall Office using the steps in the link below and see if that fixes the issue?

https://support.microsoft.com/en-us/office/download-and-install-or-reinstall-microsoft-365-or-office-2021-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658

Hope to hear from you soon.

Respectfully,

Glenn Rue

Forum Moderator

Microsoft Community

Answer 2

Hi,

sample,

data in activesheet

pic1

(column ID custom format 000)

=================

export json file on desktop (jsonFileName.json)

tested, open through python PyCharm

pic2&3

pic2

pic3

================

vba code

Answer 3

Hello, Sonam Kazmi.

We haven't heard from you in the last 72 hours, so we will be considering your issue resolved. Moving forward, we will not be monitoring this thread so if you need further assistance, please create a new thread to discuss these concerns by clicking the link below. Or click on the Ask a question option as shown in the photo.

https://answers.microsoft.com/en-us/newthread?threadtype=Questions&cancelurl=%2Fen-us%2F

Thank you for understanding.

Respectfully,

Glenn Rue