Json To Xlsx

petr_cermak/json-to-xlsx

No credit card required

The act takes a JSON input and converts it to XLSX.

Dockerfile

# This is a template for a Dockerfile used to run acts in Actor system.
# The base image name below is set during the act build, based on user settings.
# IMPORTANT: The base image must set a correct working directory, such as /usr/src/app or /home/user
FROM apify/actor-node

# Second, copy just package.json and package-lock.json since it should be
# the only file that affects "npm install" in the next step, to speed up the build
COPY package*.json ./

# Install NPM packages, skip optional and development dependencies to
# keep the image small. Avoid logging too much and print the dependency
# tree for debugging
RUN npm --quiet set progress=false \
 && npm install --only=prod --no-optional \
 && echo "Installed NPM packages:" \
 && (npm list --all || true) \
 && echo "Node.js version:" \
 && node --version \
 && echo "NPM version:" \
 && npm --version

# Copy source code to container
# Do this in the last step, to have fast build if only the source code changed
COPY  . ./

# NOTE: The CMD is already defined by the base image.
# Uncomment this for local node inspector debugging:
# CMD [ "node", "--inspect=0.0.0.0:9229", "main.js" ]

main.js

const XLSX = require('xlsx');
const Apify = require('apify');

function toXlsxBuffer(array){
    //flattenRecords(array)
    const ws = XLSX.utils.json_to_sheet(array);
    const wb = {SheetNames:['results'], Sheets:{'results': ws}};
    const wopts = {bookType:'xlsx', bookSST:false, type:'binary'};
    const wbout = XLSX.write(wb, wopts);
     
    function s2ab(s){
        const buf = new ArrayBuffer(s.length);
        const view = new Uint8Array(buf);
        for(let i=0; i!=s.length; ++i){
            view[i] = s.charCodeAt(i) & 0xFF;
        }
        return Buffer.from(buf);
    }
    
    return s2ab(wbout);
}

function flattenRecord(record){
    if(record && typeof record === 'object'){
        for(const key in record){
            const value = record[key];
            if(value && Array.isArray(value)){
                if(value.length > 0){
                    record[key] = undefined;
                    //delete record[key];
                    flattenRecords(value);
                    for(let i = 0; i < value.length; i++){
                        record[key + '/' + i] = value[i];
                    }
                }
            }
        }
    }
}

function flattenRecords(data){
    for(let i = 0; i < data.length; i++){
        flattenRecord(data[i]);
    }
}

Apify.main(async () => {
    const input = await Apify.getValue('INPUT');
    let buffer;
    
    if(Array.isArray(input)){
        console.log(`Parsing a raw data array`)
        buffer = toXlsxBuffer(input);
    }
    else if(input.storeId && input.key){
        const jsonFromStore = await Apify.newClient().keyValueStore(input.storeId)
            .getRecord(input.key)
            .then((res) => res.value);
        buffer = toXlsxBuffer(jsonFromStore);
    }
    else{
        throw new Error('Invalid input');
    }
    
    const storeId = Apify.getEnv().defaultKeyValueStoreId;
    const url = "https://api.apifier.com/v2/key-value-stores/" + storeId + "/records/results.xlsx?rawBody=1&disableRedirect=1";
    const type = "application/octet-stream";
    await Apify.setValue('results.xlsx', buffer, {contentType: type});
    await Apify.setValue('OUTPUT', {output: url});
    console.log('Output URL: ' + url);
});

package.json

{
    "name": "apify-project",
    "version": "0.0.1",
    "description": "",
    "author": "It's not you it's me",
    "license": "ISC",
    "dependencies": {
        "xlsx": "latest",
        "apify": "^2.2.2"
    },
    "scripts": {
        "start": "node main.js"
    }
}