Skip to content

Instantly share code, notes, and snippets.

@aspose-com-gists
Last active June 22, 2021 03:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aspose-com-gists/a92f28aeaffae678d3433561ec7d4193 to your computer and use it in GitHub Desktop.
Save aspose-com-gists/a92f28aeaffae678d3433561ec7d4193 to your computer and use it in GitHub Desktop.
// create a blank Workbook object
Workbook workbook = new Workbook();
// access default empty worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
// read JSON file
String fileName = "Data.json";
String content = new String(Files.readAllBytes(Paths.get(fileName)));
// set JsonLayoutOptions for formatting
JsonLayoutOptions layoutOptions = new JsonLayoutOptions();
layoutOptions.setArrayAsTable(true);
// import JSON data to default worksheet starting at cell A1
JsonUtility.importData(content, worksheet.getCells(), 0, 0, layoutOptions);
// convert imported JSON to PDF
workbook.save("output.pdf", SaveFormat.AUTO);
@aspose-com-gists
Copy link
Author

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment