This project is for the basic usage of google sheets api which can be used for many things (Test status updatation etc).
For initial setup of the project -
- Clone the project
- Replace the credentials.json file with the actual file. U can get it from here.
- Run the test and you will see a sheet created here.
This project covers following things :-
- Creating a spreadsheet
- Inserting values.
- Reading a value.
- Formatting the borders of the cell.
- Formatting the header row.
- Freezing of header row.
- Changing background, font color of the text.
- Changing the format of numbers and date as per the requirments.
- Making line graph of the data