Search
Download the converter file (Excel2XML.xlsm) from http://goo.gl/jLIol9
Convert Excel's rows into XML.
Important Note++: Due to the limitation of Excel that each formula will not be able to return more than 32,767 characters, hence both xmlAttribute() and xmlElement functions I created will return #VALUE! if the output exceeded 32,767 characters. The workaround is to partially convert the ranges and combine them together in the normal text editor.
Convert each row in Excel to JSON's array element.
Get the converter file from http://goo.gl/h2nxAK
Important Note++: Due to the limitation of Excel that each formula will not be able to return more than 32,767 characters, hence the jsonArray() function I created will return #VALUE! if the output exceeded 32,767 characters. The workaround is to partially convert the ranges and combine them together in the normal text editor. Don't forget to remove extra square brackets [.
Download Excel spreadsheet from http://goo.gl/PJH5yk
I created the user-defined function in Excel spreadsheet for converting data in Excel to Apple Property List (plist) file format.
Important Note++: Due to the limitation of Excel that each formula will not be able to return more than 32,767 characters, hence the plist() function I created will return #VALUE! if the output exceeded 32,767 characters. The workaround is to partially convert the ranges and combine them together in the normal text editor.
