Here is the data as an example:
- Hello I Have A Excel File With Data That Has 100 Columns And 1000 Rows I Need To Create A Json File That Follows The 1 (200.4 KiB) Viewed 25 times
Hello, I have a Excel file with data that has 100 Columns and 1000 Rows. I need to create a .JSON file that follows the
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Hello, I have a Excel file with data that has 100 Columns and 1000 Rows. I need to create a .JSON file that follows the
Hello, I have a Excel file with data that has 100 Columns and 1000 Rows. I need to create a .JSON file that follows the same format with same headers in the Excel data. Please provide a code preferably in VBA in Excel. Thank you.
Here is the data as an example:
Cre Display Number P1529687 09 09 P122225722 09 os P199922855 P1999912222 P19996891 P1992298225 P1992222178 09 09 P19991595 0 0 0 Description Client ID Client Name Grend girage Hugdingn, ggg / Grege Zugg 1305822616 Client 1 Gerdin gidited / puntun pun eqgident 1305823006 Client 2 Univerniti Hunpitegn Heegth ninted Ing/ 1305822616 Client 1 (RPn-pan) Gerdent denegedent / ntephene 1305822016 Client 3 (RPn-pan) Tideweter durtgege / Rupert He 1305822016 Client 3 nnep, Ing. / nNePP 1305822421 Client 4 Tedpur neegi Internetiuneg, Ing./ E-qudde 1305850966 Client 5 Higgn Fgetgher & deqk/nhekine urtege 1305823186 Client 6 denett Phegpn / 2972-2977 ieer uf eqquui 1305822826 Client 7 denett Phegpn / qenhqegg, Ing. 1305822826 Client 7 EPIP q&P / Peqifiq eggienge dediqeg gent 1305822616 Client 1 Kgeinfegder / prightun ntetiun / Witt v. Di 1306327846 Client 8 Gennger/qRd Prupertien Gruup (Whuge! 1305822571 Client 9 Engeu, Ing. / 2972-2977 ieer uf eqquunt (i 1306327846 Client 8 Fguur qurpuretiun / Penque gede Prujeqt 1305822616 Client 1 Jequpn Engineering Gruup Inq. / Righerd 1305822616 Client 1 peker & Huntetger ggp / Egeqtruguz Hude 1305822826 Client 1 ederiqen pureeu uf nhipping (epn) / qureg 1305822616 Client 1 nhepperd duggin Righter & Hedptun ggp / 1305822571 Client 9 nhepperd duggin Righter & Hedptun ggp / 1305822571 Client 9 Prugupiu quri Hergreeven & nevitqh ggp/ 1305822571 Client 9 Infur Enterprine eppgiqetiunn, gP (IGn)/I] Client 5 Infur Enterprine eppgiqetiunn, gp (In)/: 1305850966 Client 5 quverin / Denteg qere uf nuuth Jernei (Rer 1305822616 Client 1 Client Reference Client Location Status peeZg799992857792 nen Frengingu Closed perpigen: p7222F1995322722eeD / zan: Closed pEe7g799992872921 nen Frengingu Closed 3272-97 nen Frenqingu Closed nen Frengingu Closed Closed pEeZg799992892522 nen Frengingu Closed p9792pN3972997 Closed QpE: 593599N, ezin 737298, sguidn: N2 Closed Everent #3-2289 Closed pEeZg799992922272 nen Frengingu Closed qhupp: 2999973932-997, Irunnhure: PR Closed p972227299772 Closed 7998298279-997 Closed 2.99322E+11 Closed TpD, Closed Neutigun #792279, ezin pH72279222 / Closed pEeZg799992889289 Closed Closed Closed p9599PU7799995eDe Closed pEe2g79999282339 nen Frenqinqu Closed pEe2g799992922598 nen Frenqinqu Closed pEe2g799992922522 nen Frenqinqu Closed 0 O O P199122721 P199122721/996 P19999895 P19998296 P19959562 P199786226 P199222686 P199952222/995 P19192997 P19982269 P199992219 P19191821 P19968121 P15222689 P19119765 P19121226 O O e c
Here is the data as an example:
Cre Display Number P1529687 09 09 P122225722 09 os P199922855 P1999912222 P19996891 P1992298225 P1992222178 09 09 P19991595 0 0 0 Description Client ID Client Name Grend girage Hugdingn, ggg / Grege Zugg 1305822616 Client 1 Gerdin gidited / puntun pun eqgident 1305823006 Client 2 Univerniti Hunpitegn Heegth ninted Ing/ 1305822616 Client 1 (RPn-pan) Gerdent denegedent / ntephene 1305822016 Client 3 (RPn-pan) Tideweter durtgege / Rupert He 1305822016 Client 3 nnep, Ing. / nNePP 1305822421 Client 4 Tedpur neegi Internetiuneg, Ing./ E-qudde 1305850966 Client 5 Higgn Fgetgher & deqk/nhekine urtege 1305823186 Client 6 denett Phegpn / 2972-2977 ieer uf eqquui 1305822826 Client 7 denett Phegpn / qenhqegg, Ing. 1305822826 Client 7 EPIP q&P / Peqifiq eggienge dediqeg gent 1305822616 Client 1 Kgeinfegder / prightun ntetiun / Witt v. Di 1306327846 Client 8 Gennger/qRd Prupertien Gruup (Whuge! 1305822571 Client 9 Engeu, Ing. / 2972-2977 ieer uf eqquunt (i 1306327846 Client 8 Fguur qurpuretiun / Penque gede Prujeqt 1305822616 Client 1 Jequpn Engineering Gruup Inq. / Righerd 1305822616 Client 1 peker & Huntetger ggp / Egeqtruguz Hude 1305822826 Client 1 ederiqen pureeu uf nhipping (epn) / qureg 1305822616 Client 1 nhepperd duggin Righter & Hedptun ggp / 1305822571 Client 9 nhepperd duggin Righter & Hedptun ggp / 1305822571 Client 9 Prugupiu quri Hergreeven & nevitqh ggp/ 1305822571 Client 9 Infur Enterprine eppgiqetiunn, gP (IGn)/I] Client 5 Infur Enterprine eppgiqetiunn, gp (In)/: 1305850966 Client 5 quverin / Denteg qere uf nuuth Jernei (Rer 1305822616 Client 1 Client Reference Client Location Status peeZg799992857792 nen Frengingu Closed perpigen: p7222F1995322722eeD / zan: Closed pEe7g799992872921 nen Frengingu Closed 3272-97 nen Frenqingu Closed nen Frengingu Closed Closed pEeZg799992892522 nen Frengingu Closed p9792pN3972997 Closed QpE: 593599N, ezin 737298, sguidn: N2 Closed Everent #3-2289 Closed pEeZg799992922272 nen Frengingu Closed qhupp: 2999973932-997, Irunnhure: PR Closed p972227299772 Closed 7998298279-997 Closed 2.99322E+11 Closed TpD, Closed Neutigun #792279, ezin pH72279222 / Closed pEeZg799992889289 Closed Closed Closed p9599PU7799995eDe Closed pEe2g79999282339 nen Frenqinqu Closed pEe2g799992922598 nen Frenqinqu Closed pEe2g799992922522 nen Frenqinqu Closed 0 O O P199122721 P199122721/996 P19999895 P19998296 P19959562 P199786226 P199222686 P199952222/995 P19192997 P19982269 P199992219 P19191821 P19968121 P15222689 P19119765 P19121226 O O e c
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!