go>> gcal-exporter>> 返回
项目作者： kuxn

项目描述 ：
Export Google Calendar events to Google Spreadsheets
高级语言： Java
项目地址: git://github.com/kuxn/gcal-exporter.git
创建时间： 2017-01-15T22:09:31Z
项目社区：https://github.com/kuxn/gcal-exporter
开源协议：GNU General Public License v3.0
下载


Google Calendar Exporter

Build Status

Export Google Calendar to Google Spreadsheets with gcal-exporter in Java. All the methods in Gsheet.java and Gspread.java are reusable.

Prerequisites

  • Java 1.8 or greater
  • Gradle 4.10 or greater

Run

  1. $ gradle fatJar
  2. $ java -jar ./build/libs/gcal-exporter-1.2.jar

After entering the start date and end date of the calendar events to export, it will open a new window or tab in the default browser window for the authorization.

Google Calendar API

Get Calendars List

  1. Gcal gcal = new Gcal(timeStart, timeEnd);
  2. List<CalendarListEntry> calendars = gcal.getCalendars();

Print Calendars or Events

  1. // Print name, id, and time zone of calendars
  2. gcal.printCalendarInfo();
  4. // Print all the events in all calendars
  5. gcal.printAllEvents();

Get Data from Calendars

  1. // Get all the events from a calendar
  2. List<List<String>> data = gcal.getDataFromCalendar(CalendarListEntry calendar);
  4. // Get a number of events from a calendar
  5. List<List<String>> data = gcal.getDataFromCalendar(CalendarListEntry calendar, Integer numberOfEvents);

Google Spreadsheets API

Get a Spreadsheet

  1. Gsheet gsheet = new Gsheet();
  3. // Create a spreadsheet
  4. spreadsheet = gsheet.createNewSpreadsheet(String spreadsheetTitle);
  6. // Find a spreadsheet
  7. spreadsheet = gsheet.getSpreadsheet(String spreadsheetId);

Print Information of a Spreadsheet

  1. // Print sheet name and sheet id
  2. gsheet.printSheetInfo(Spreadsheet spreadsheet);
  4. // Print data in a sheet
  5. gsheet.printSheetData(Spreadsheet spreadsheet, String sheetTitle);

Update Spreadsheet Title

  1. gsheet.updateSpreadsheetTitle(Spreadsheet spreadsheet, String spreadsheetTitle);

Get a Sheet

  1. // Add a sheet
  2. newSheet = gsheet.addNewSheet(Spreadsheet spreadsheet, String sheetTitle);
  4. // Find a sheet
  5. sheet = gsheet.findSheet(Spreadsheet spreadsheet, String sheetTitle);

Delete a Sheet

  1. gsheet.deleteSheet(Spreadsheet spreadsheet, Integer sheetId);

Clear a Sheet

  1. gsheet.clearSheet(Spreadsheet spreadsheet, Sheet sheet);

Append Row of Data to a Sheet

  1. // Append data to the default sheet created with the spreadsheet
  2. gsheet.appendRowDtata(Spreadsheet spreadsheet, List<String> rowData);
  4. // Append data to a new sheet
  5. gsheet.appendRowDtata(Spreadsheet spreadsheet, Sheet sheet, List<String> rowData);

Import Data to a Sheet

  1. // Import data to the default sheet
  2. gsheet.importData(Spreadsheet spreadsheet, List<List<String>> data);
  4. // Import data to a new sheet
  5. gsheet.importData(Spreadsheet spreadsheet, Sheet sheet, List<List<String>> data);

Format a Sheet

  1. // Resize all columns based on the contents of the cells in the default sheet
  2. gsheet.resizeColumns(Spreadsheet spreadsheet);
  4. // Resize all columns based on the contents of the cells in a given sheet
  5. gsheet.resizeColumns(Spreadsheet spreadsheet, Sheet sheet);

Sort Data

  1. // Sort data in rows based on a sort order of a column in the default sheet
  2. gsheet.sortByColumn(Spreadsheet spreadsheet, Integer columnIndex, Integer startRowIndex, String sortSpec);
  4. // Sort data in rows based on a sort order of a column in the given sheet
  5. gsheet.sortByColumn(Spreadsheet spreadsheet, Sheet sheet, Integer columnIndex, Integer startRowIndex, String sortSpec);