sahujaunpuri

sahujaunpuri / Code.gs

Created October 6, 2018 22:10 — forked from adborden/Code.gs

Turn google spreadsheet into a JSON API

	function doGet(request)
	{
	var spreadsheetId = 'YOUR SPREADSHEET ID HERE';
	var sheetId = request.parameters.sheet \|\| 0;

	// Get data from the sheet
	var sheet = getSheet(spreadsheetId, sheetId);
	var dataArray = getData(sheet);

	// Normalize the headers

sahujaunpuri / ReadWriteExcelFile.java

Created August 10, 2018 08:40 — forked from madan712/ReadWriteExcelFile.java

Read / Write Excel file (.xls or .xlsx) using Apache POI

	import java.io.FileInputStream;
	import java.io.FileOutputStream;
	import java.io.IOException;
	import java.io.InputStream;
	import java.util.Iterator;

	import org.apache.poi.hssf.usermodel.HSSFCell;
	import org.apache.poi.hssf.usermodel.HSSFRow;
	import org.apache.poi.hssf.usermodel.HSSFSheet;
	import org.apache.poi.hssf.usermodel.HSSFWorkbook;