Icon

08_​Google_​Sheet-meets-Excel

Public Google Sheet meets Excel Sheet.

Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we want to compare the monthly and YTD revenues for both years. Will Excel Sheets and Google Sheets blend? Excel sheet is accessed via an Excel Reader node; Google sheet via the new Google Sheets nodes available with KNIME Analytics Platform 3.5. This workflow demonstrates an example of access to both a public (no authorization required) or a private (OAuth2 authorization required) Google Sheet document. All you need is a Google account which has an access to the document. ... yes, they blend!

2016 Restaurant Transactions 2017 Restaurant Transactions Semi-automatic way to build a REST query Google Sheet meets Excel Sheet Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we want to compare the monthly andYTD revenues for both years. Will Excel Sheets and Google Sheets blend? Excel sheet is accessed via an Excel Reader node; Google sheet via the new Google Sheets nodes available with KNIME Analytics Platform 3.5.This workflow demonstrates an example of access to both a public (no authorization required) or a private (OAuth2 authorization required) Google Sheetdocument. All you need is a Google account which has an access to the document.Blog post available at https://www.knime.org/blog/GoogleSheet-meets-Excel-part2 ... yes, they blend! To visualize calculate YTD valuescalculate revenuesfor each monthYTD Revenues2017 vs. 2016Monthly Revenues2017 vs. 2016join aggregated2016 and 2017dataintroduce colors for monthly andYTD revenuesPublic Access to Google Sheet with 2017 datacalculate revenuesfor each monthcalculate YTD values2016 dataCreate connection toGoogle SheetsserviceConnect to Google Moving Aggregation Total Sum by Month Bar Chart(JavaScript) Bar Chart(JavaScript) Join + MissingValues Colors Google SheetsReader Total Sum by Month Moving Aggregation Excel Reader (XLS) Google SheetsConnection GoogleAuthentication 2016 Restaurant Transactions 2017 Restaurant Transactions Semi-automatic way to build a REST query Google Sheet meets Excel Sheet Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we want to compare the monthly andYTD revenues for both years. Will Excel Sheets and Google Sheets blend? Excel sheet is accessed via an Excel Reader node; Google sheet via the new Google Sheets nodes available with KNIME Analytics Platform 3.5.This workflow demonstrates an example of access to both a public (no authorization required) or a private (OAuth2 authorization required) Google Sheetdocument. All you need is a Google account which has an access to the document.Blog post available at https://www.knime.org/blog/GoogleSheet-meets-Excel-part2 ... yes, they blend! To visualize calculate YTD valuescalculate revenuesfor each monthYTD Revenues2017 vs. 2016Monthly Revenues2017 vs. 2016join aggregated2016 and 2017dataintroduce colors for monthly andYTD revenuesPublic Access to Google Sheet with 2017 datacalculate revenuesfor each monthcalculate YTD values2016 dataCreate connection toGoogle SheetsserviceConnect to Google Moving Aggregation Total Sum by Month Bar Chart(JavaScript) Bar Chart(JavaScript) Join + MissingValues Colors Google SheetsReader Total Sum by Month Moving Aggregation Excel Reader (XLS) Google SheetsConnection GoogleAuthentication

Nodes

Extensions

Links