JavaScript improvement for Google tables (import data from different files)
7 USDНеобходимо доработать/исправить скрипт (ниже), который в гугл таблицах, основываясь на ссылках на файлы (ссылки находятся лист№3, столбец А) записывает данные (первые четыре столбца) построчно, без пропусков, на лист "СВОД"
var i=2;
var g=2;
var h=2;
var rs = SpreadsheetApp.getActiveSpreadsheet();
var svod = rs.getSheetByName('Свод');
var sheet1 = rs.getSheetByName('Лист1');
var sheet2 = rs.getSheetByName('Лист2');
var sheet3 = rs.getSheetByName ('Лист3');
function superfunc() {
var ss = SpreadsheetApp.openByUrl(sheet3.getRange("A"+i).getValue());
var Dinam = ss.getSheetByName('Лист2');
for (h=2;h<=4;h++){
ss = SpreadsheetApp.openByUrl(sheet3.getRange("A"+i).getValue());
Dinam = ss.getSheetByName('Лист2');
for (g=2;g<=sheet1.getRange(1, 7).getValue();g++) {
svod.getRange("A"+i).setValue(Dinam.getRange("A"+g).getValue());
svod.getRange("B"+i).setValue(Dinam.getRange("B"+g).getValue());
svod.getRange("C"+i).setValue(Dinam.getRange("C"+g).getValue());
svod.getRange("D"+i).setValue(Dinam.getRange("D"+g).getValue());
i++;
}
}
}
Client's feedback on cooperation with freelancer
JavaScript improvement for Google tables (import data from different files)The young! Everything quickly and quality!
Profile deleted
Freelancer's feedback on cooperation with client
JavaScript improvement for Google tables (import data from different files)Переписала функцию на javascript по чётко поставленному техзаданию. Шустрый и адекватный Заказчик. Была рада сотрудничеству.
Profile deleted
-
А что тут не так? На первый взгляд должно работать (сильно не вникала).
Можете доступ дать? Так сказать по месту посмотреть.
Аккаунт гугл [email protected]
-
function superfunc777() {
var rs = SpreadsheetApp.getActiveSpreadsheet(); // наша таблица
var svod = rs.getSheetByName('Свод');
var sheet3 = rs.getSheetByName ('Лист3');
var i = 2; //счетчик строки на листе СВОД
for (var с = 2; с <= 4; с++){
var ss = SpreadsheetApp.openByUrl(sheet3.getRange("A" + с).getValue());
var Dinam = ss.getSheetByName('Лист2');
for (var q = 2; q <= Dinam.getLastRow(); q++) {
svod.getRange("A" + i).setValue(Dinam.getRange("A" + q).getValue());
svod.getRange("B" + i).setValue(Dinam.getRange("B" + q).getValue());
svod.getRange("C" + i).setValue(Dinam.getRange("C" + q).getValue());
svod.getRange("E" + i).setValue(Dinam.getRange("D" + q).getValue());
i++;
}
}
} -
Current freelance projects in the category JavaScript
Exchange service
510 USD
There are working exchangers, it is necessary to rely on the example, make a cryptocurrency exchanger: Design and code can be taken completely from a working website, that is - make a copy. The exchange rate and other data for the exchange - what I could set manually. The… JavaScript, Web programming ∙ 16 proposals |
Writing software for creating an Open Book on the Solana network
107 USD
During the creation of interchangeable tokens (SPL token) on the Solana network, it is necessary to automate the process of creating an Open Book for the token and speed it up by increasing transaction fees. Software functions: - Create Open Book - Set a "tea" limit on the… Java, JavaScript |
Website layout according to the design.
510 USD
Good day. There is a layout in Figma: https://www.figma.com/file/RGVIymprYc4QaiJ5qp3iwL/LayerGame?type=design&node-id=0-1&mode=design There is a UI kit and a ready-made layout of the Main page, implemented in React, animations are done using GSAP. It is necessary to layout 2… HTML and CSS, JavaScript ∙ 36 proposals |
ParallaxIt is necessary to make such a parallax as here https://www.bangbangforever.com/#artists, that is, a video block video (everything is already laid out) and also part of the parallax is ready, stack Next.js JavaScript ∙ 2 proposals |
Set up Facebook Pixel and Google Analytics events on the websiteSet up Facebook Pixel and Google Analytics events on the website. Do this through the website admin panel, simply add scripts there or through GTM. JavaScript, Web programming ∙ 7 proposals |