2D, 3D, game, games, online game, game development, game engine, programming, OpenGL, Open AI, math, graphics, design, graphic, graphics, game development, game engine, programming, web development, web art, web graphic, arts, tutorial, tutorials,
miercuri, 16 aprilie 2025
News : Google Apps Script - add movies from website into new sheet.
This source code with GAScript add few movies from cinemagia website:
The commant the lines from the last post tutorial and use this source code.
This will add movies into separated sheet by date, see the source code:
// try {
// const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
// const currentDate = new Date();
// extractedData.forEach((movie, rowIndex) => {
// if (movie.title !== "N/A" && movie.image !== "N/A") {
// const imageFormula = `=IMAGE("${movie.image}")`;
// const rowIndexAdjusted = sheet.getLastRow() + 1;
// sheet.appendRow([currentDate, movie.title, imageFormula, movie.channel, movie.time]);
// sheet.setRowHeight(rowIndexAdjusted, 76); // Set row height to 330px
// }
// });
// Logger.log("Processed movies count: ", extractedData.length);
// } catch (error) {
// Logger.log("Error adding data to spreadsheet: ", error.message);
// }
try {
const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
const currentDate = new Date();
// Formatăm data curentă pentru numele sheet-ului
const formattedDate = Utilities.formatDate(currentDate, SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone(), "yyyy-MM-dd");
const sheetName = `Data-${formattedDate}`;
// Verificăm dacă sheet-ul cu acest nume există deja
let sheet = spreadsheet.getSheetByName(sheetName);
if (!sheet) {
// Creăm un nou sheet dacă nu există
sheet = spreadsheet.insertSheet(sheetName);
}
extractedData.forEach((movie) => {
if (movie.title !== "N/A" && movie.image !== "N/A") {
const imageFormula = `=IMAGE("${movie.image}")`;
const rowIndexAdjusted = sheet.getLastRow() + 1;
sheet.appendRow([currentDate, movie.title, imageFormula, movie.channel, movie.time]);
// Păstrăm formatarea originală pentru înălțimea rândurilor
sheet.setRowHeight(rowIndexAdjusted, 76);
}
});
} catch (error) {
console.error("A apărut o eroare:", error.message);
}
Posted by
Cătălin George Feștilă
Labels:
2025,
2025 news,
google,
Google Apps Script,
news,
open source,
source code,
tutorial,
tutorials

News : Human Heritage - Cinematic Reveal Trailer
We are thrilled to unveil the official trailer for Human Heritage, a groundbreaking historical RPG built in Unreal Engine 5. Winner of the prestigious Global Entertainment Awards 2025, this game promises to redefine storytelling and immersive gameplay.
News : Viewing HTML in your Terminal by Kris Occhipinti.
... another video from the Kris Occhipinti - official youtube videos.
This is an old channel with good content that I was looking at about 10 years ago... My internet content is being cut for some reason and I saw this new video today.
Posted by
Cătălin George Feștilă
Labels:
2025,
2025 news,
news,
tutorial,
tutorials,
video,
video card,
youtube

Abonați-vă la:
Postări (Atom)