Macro for Excel 2010 Data to Notepad in a specific format
I'm currently trying to develop a macro that allows me to transfer excel data into Notepad in the following format.
$json['Name'] = 'Taylor Street., west side, in front of Hamilton Hotel';
$json['Latitude'] = '11.111111';
$json['Longitude'] = '-222.222222';
$json['StreetAddress'] = '1856 Taylor Street';
$json['ZipCode'] = '28356';
$data = $json;
The excel columns are Location, Area, Lat Long, Reference Marks, Address.
I have about 100 rows of data in the spreadsheet.
Any help on how I do this would be appreciated!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1