I’m trying to parse an Excel spreadsheet (.xlsx) into JSON.
I’m using the SheetJS node package for it.
However I can’t realize such a simple thing as – how do I get a column name in the same format as it is stored internally?
Below is my code:
function _buildColumnsArray(range) {
// range = "A1:CA38"
// ...
// should return ['A', ..., 'Z', 'AA', ..., 'AZ', 'BA', ..., 'BZ', 'CA'...]
}
// --------
var workbook = XLSX.readFile(fileUrl),
sheets = workbook.Sheets,
result = {};
result.sheetNames = [];
for (var i = 0; i < workbook.SheetNames.length; i++) {
var sheet = workbook.Sheets[workbook.SheetNames[i]],
csvSheet = XLSX.utils.sheet_to_csv(sheet);
// '!ref' referring to a specific range by docs
if (sheet["!ref"]) {
var columns = _buildColumnsArray(sheet["!ref"]),
rows = _buildRowsArray(columns, csvSheet);
// build final result
result[workbook.SheetNames[i]] = {
columns: columns,
rows: rows
};
result.sheetNames.push(workbook.SheetNames[i]);
}
}
Here is what I’m currently trying which is not perfectly working: https://jsfiddle.net/t8hej9hu/
prednisone 500 mg – prednisone 15 mg tablet deltasone
modafinil online – provigil for sale provigil
mexico pharmacy accutane – order accutane no prescription how much is accutane prescription
purchasing amoxicillin online – amoxicillin brand over the counter buy amoxicillin 500
buy vardenafil online – bruno vardenafil generic vardenafil bestellen
buy ivermectin nz – stromectol where to buy ivermectin 0.5%
otc cialis us – cialis com compare cialis prices online
ivermectin 3mg dosage – covid and ivermectin ivermectin oral solution
where to get accutane prescription – accutane india cost accutane 1mg
buy lyrica online india – lyricapt.com cvs online pharmacy
walgreens amoxicillin price – price of amoxicillin without insurance buy amoxicilin 500
viagra price canada – brand viagra from canada generic viagra medication
stromectol south africa – ivermectin 3mg online ivermectin 18mg
how to get prednisone tablets – prednisone generic online prednisone
modafinil adhd – modafinil and weight loss buy modafinil online
azithromycin 500mg pills – zithromax for sale buy azithromycin 100mg
buying furosemide online – medicine lasix 40 mg generic furosemide 20 mg
clomiphene generic – clomid 50 mg clomid prescription
ventolin inhalers – site ventolin purchase
cytotec online australia – where can i buy cytotec over the counter in usa purchase cytotec
can i buy 40mg doxycycline online – doxycycline tablets 100mg doxycycline
neurontin 100mg capsule price – neurontin 300 600 mg levothyroxine uk
us pharmacy viagra online – generic viagra on line
cialis brand online – canada cialis pills chewable tadalafil
buy vardenafil online overnight delivery – real vardenafil online buy vardenafil 20mg
prednisone 20 mg prices – buy prednisone 10mg prednisone
accutane price nz – how to get accutane without prescription accutane generic south africa
amoxil 500 mg – amoxicillin 500 mg for sale in canada today rx amoxicillin 500mg
methylprednisolone tablet 16 mg – order medrol lyrica medication price
best website for writing essays – best essay helper buy a dissertation
viagra cost canada – Viagra approved buy sildenafil 25 mg
stromectol price in india – ivermectin price usa stromectol 0.1
where can you get prednisone – prednisone on line prednisone 1 mg tablet
ventolin tablet price – ventolin tablet price ventolin cost canada
cytotec medicine where to buy – how to buy cytotec cytotec medicine price in india
doxycycline over the counter singapore – prednisolone tablets for sale uk prednisolone 25 mg cost australia
buy stromectol usa – ivermectin 9mg cheap stromectol
ivermectin without a doctor prescription – ivermectin 2ml ivermectin 3mg
cheapest sildenafil – sildenafil cost generic sildenafil online
tadalafil 20mg – buy tadalafil online cheap tadalafil 10 mg
accutane south africa – accutane prices canada accutane from canada pharmacy
order stromectol – ivermectin australia ivermectin 2mg
canadian pharmacy sildenafil – Cialis medication buy generic cialis no prescription
vardenafil canada – generic vardenafil online new ed drugs
does hydroxychloroquine cause hair loss – prednisone 20mg no prescription 60 mg of prednisone
cenforce 120mg online – ceneforce.com cenforce 120 paypal
xenical generic name – orlistat dmf xenical uk price
viagra pills price in usa – viagra us 100mg sildenafil no rx canadian
order cialis online india – best cialis price how to order cialis online safely
steroid prednisone – 20mg daily prednisone 50 mg prednisone from canada
ivermectin cost in usa – stromectol tablet ivermectina
best canadian online pharmacy cialis – cialis super active 100mg cialis for sale
tadalafil generic cialis – Low price cialis order cialis daily
research paper editing – thesis writing services assignments for sale
ivermectin over the counter uk – oral ivermectin cost stromectol 0.1
prednisone 4mg – cost of prednisone buy prednisone 20mg without a prescription best price
brand sildenafil 150mg – order tadalafil 20mg pills order tadalafil 5mg online
sildenafil 200mg sans ordonnance en france – sildenafil 200mg en ligne tadalafil 5mg generique
ivermectin 3mg price – provigil 100mg drug stromectol tablets uk
https://cialiswbtc.com/
buy lyrica 150mg online – clomid 50mg cheap order zithromax 500mg for sale
buy doxycycline 100mg pills – order synthroid 150mcg sale cheap levothyroxine for sale
tadalafil without a doctor prescription tadalafil without a doctor prescription
cost cenforce – order acyclovir 800mg generic acyclovir online buy
order atarax 25mg generic – order hydroxyzine 10mg pill crestor 20mg usa
order chloroquine 250mg sale – purchase baricitinib generic purchase viagra
tadalafil 10mg canada – buy tadalafil 10mg online ivermectin 3 mg online
https://cialiswbtc.com/ tadalafil brands
generic cialis tadalafil tadalafil online
cost of cialis tadalafil order online no prescription
best price usa tadalafil tadalafil generic where to buy
tadalafil brands where to order tadalafil tablets
https://cialisvet.com/ cheapest tadalafil cost
비아몰 정품 비아그라 구매 사이트 인도 시알리스 직구
stromectol 12 mg for sale https://www.ivermectinoge.com/
ivermectin 12 mg ivermectin for covid cheapest stromectol online