Skip to content

Instantly share code, notes, and snippets.

@afaqahmedkhan
Last active April 8, 2019 07:16
Show Gist options
  • Save afaqahmedkhan/5b38febefce36460993ae53d9ab46c49 to your computer and use it in GitHub Desktop.
Save afaqahmedkhan/5b38febefce36460993ae53d9ab46c49 to your computer and use it in GitHub Desktop.
dnow excel sheet to json conversion for internal use
function camelize(str) {
return str.replace(/(?:^\w|[A-Z]|\b\w)/g, function(word, index) {
return index == 0 ? word.toLowerCase() : word.toUpperCase();
}).replace(/\s+/g, '');
}
const cols = 'CUSTOMER,COUNTRY,SITE,FIELD LOCATION,VALVE MANUFACTURER,VALVE BRAND,VALVE TYPE,VALVE SUB TYPE,VALVE MODEL,SHORT TEXT DESCRIPTION,Long Text Description ,OEM MATERIAL NUMBER,Valve Data Sheet,QTY,Bore Type,NPS 1,NPS 2,Bore Size ,Pressure Rating NPS 1,Pressure Rating NPS 2,End Connection 1,End Connection 2,Design Temperarture (Max),Design Temperarture (Min),Operating Temperarture (Max),Operating Temperarture (Min),Body Design,Obturator Design,Seat Design,Body Material,Obturator Material,Seat Ring Material,Seat Insert Material,Stem & Trunnion,Primary Seal Type,Primary Seal Material,Gaskets,Packing,Lockable Device,Anti-Static,Ball Position Indicator,Stem Injection Port,Injection Port/Seat,Vent Plug,Drain Plug,Stem Extension,Overlay on Body,Overlay Material,Actuated/Manual,Operator Manufacturer,Operator Model,Operator Type,Operator Description,VALVE SERIAL NUMBER,Operator Serial Number,Valve Manufacture Date,Customer Material Number,Material Group Code,Qty on Order,Recommended Min,Recommended Max';
const colsArray = cols.split(",");
let json='';
for(i=0;i<colsArray.length;i++){
y+= '{ title: \''+ colsArray[i] + '\', dataIndex: \''+ camelize(colsArray[i].toString().toLowerCase()).replace(/[^\w\-]+/g, '').replace(/\d+/g, '') + '\',' + ' key: \''+ camelize(colsArray[i].toString().toLowerCase()).replace(/[^\w\-]+/g, '').replace(/\d+/g, '') + '\',}, ';
}
console.log(json);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment