Google script expert

Closed Posted 3 years ago Paid on delivery
Closed Paid on delivery

Here is a google sheet with the layout information we like to use.

[login to view URL]

Please advise if you can prepare the function using Google Script.

The PDF will be created using the Gray Range - print selected range - to fit on page.

THen save PDF if Google Drive using the name provided on the sheet.

Like to use Google Script because function will be included in a larger configuration.

We need the function to use named ranges to define the area of the spread sheet to be printed, because the areas will change depending on the case.

The area to be printed needs to be defined by the opposite corners (named ranges).

Print Gray Range, but the range is defined by the the two range variables that are passed along to the function.

some times we need to print more lines, and some time less lines.

We can define the upper and lower corner using Named Ranges to define the area to be printed.

THe File name will be a cell that will be updated with the correct file name every time the function is called to print.

The function should be called from the button on the sheet. (Click Button to Create -PDF- File).

Put "Don't worry" in your bid

thanks

JavaScript

Project ID: #27590186

About the project

4 proposals Remote project Active 3 years ago

4 freelancers are bidding on average $75 for this job

ayesha0124

Hello,I have read the job description and I am interested in this job. I have 8 years experience in developing products using JavaScript. I have read your requirements and am ready to start working for you. • Attract More

$80 USD in 19 days
(1 Review)
3.6
yyer

Don't worry We can implement PDF export as a google script function and it will work on button click. The function will not accept any arguments in this case. So corner ranges names (top-left and bottom-right corners r More

$70 USD in 3 days
(9 Reviews)
3.5
yolberjp

Hi, nice to meet you. I think I can help you. I have previously exported a specific sheet to PDF. But I see that what you want is a more customized export to certain specific cells that you will define previously. I c More

$80 USD in 3 days
(0 Reviews)
0.0