sheet tag

31 questions

1 answers
135 views
0

Automatically enter a spreadsheet quote into another spreadsheet sales file with links, amounts, subject lines, etc.

This is my first time posting.I'd like to create a file for an E-quote with a spreadsheet and automatically enter the value of a particular cell in the file into a separate spreadsheet sales file.I wo...

google-apps-script google-spreadsheet

2 years ago

1 answers
129 views
0

I want to fill the background color and character color separately in the conditional format of Google spreadsheet.

I would like to fill the background color and character color separately in the conditional format of the Google spreadsheet.Specifically, the settings like the attached image are

google-apps-script google-spreadsheet

2 years ago

1 answers
126 views
0

About sending by MailApp.sendEmail;

Nice to meet you.I am currently working on a form for accepting applications in Blogger.To confirm the contents of the application, an automatic reply email is sent to the applicant via script from th...

google-spreadsheet gmail

2 years ago

1 answers
136 views
0

How do I get the last row of multiple sheets and put them together into a new row in an Excel VBA or Google Apps Script?

Please check the sheet below first.https://docs.google.com/spreadsheets/d/1AlwgQLEZoZz_vWz0ZqKld528ViLAl8x2nR4SZz0VoHA/edit#gid=0There is an Excel file that records the monthly inventory of each produ...

google-apps-script vba excel google-spreadsheet

2 years ago

1 answers
135 views
0

Google Form Auto-Reply E-mails Are No Longer Sent Due to Errors

From the Google form spreadsheet, I set up the Tools > Script Editor edit to receive an automated reply email when I submit the form.(See script, trigger settings at the bottom) It worked fine for a w...

google-apps-script google-spreadsheet

2 years ago

1 answers
88 views
0

I want to exceed the request limit on the spreadsheet.

https://tanuhack.com/operate-spreadsheet/ #PythonUsing this site as a reference, we are writing data from the Python program onto a spreadsheet.According to the information on the page above, The maxi...

python google-spreadsheet

2 years ago

1 answers
130 views
0

Error adding data frame to Google spreadsheet: type.googleapis.com/google.protobuf.ListValue

I would like to reflect the data (one line) that I have crawled to the bottom line of the spreadsheet, but the error below appears and does not reflect well.Is there a solution?codeJSON_KEYFILE= 'JSON...

python python3 google-spreadsheet

2 years ago

2 answers
128 views
0

How to display " (double quote) as a character in a cell

First, if you type Taro Yamada in A1 with the cell you want to refer to as A1 = My name is &A1&Then, the cell says My name is Taro Yamada, but Attempting to display name: Taro Yamada, =name:&a...

google-spreadsheet

2 years ago

1 answers
98 views
0

a way of describing a date that is displayed in a table

How do I improve the script below?I would like the date to be written in mmdddyyyy like 11/12/2017, but I can't help but write Nov12. Can you fix it?function getWeatherData(){// Seat Settingsvars = Sp...

javascript google-spreadsheet

2 years ago

1 answers
127 views
0

difference between getActive() and getActiveSpreadsheet()

I am currently studying to make various things using Google Apps script.I'm trying to manipulate the sheet with a spreadsheet, but I have a question after seeing the reference.In the SpreadsheetApp cl...

google-apps-script google-spreadsheet

2 years ago

- 2 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656