Share
Report
2Hey there!
We have a Microsoft Forms taking answers. I've made a flow which counts the amount of rows in the underlying Excel file and stores this value in yet another Excel file. What I'm now trying to do is read the value from that Excel file using Javascript in order to show the value on our website.
Using Javascript I seem to be unable to read the Excel file directly from OneDrive. Also, there must be an easier way which only uses Power Automate to do what I'm trying to do. Anyone here who can hint me in the right direction?
I don't have any Premium features as we are a mere non-profit sports association.
My Javascript which isn't reading the OneDrive Excel file (helped out by ChatGPT:
// Laad de SheetJS-library dynamisch
const script = document.createElement("script");
script.src = "https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js";
script.onload = function() {
// Zodra de SheetJS library geladen is, start het ophalen van de Excel-data
fetchExcel();
};
document.head.appendChild(script);
const script = document.createElement("script");
script.src = "https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js";
script.onload = function() {
// Zodra de SheetJS library geladen is, start het ophalen van de Excel-data
fetchExcel();
};
document.head.appendChild(script);
// Definieer de fetchExcel-functie
async function fetchExcel() {
const url = 'https://weespfc-my.sharepoint.com/:x:/g/personal/schoolvoetbal_fcweesp_nl/ESHQUaPEePNFqop0hU77d_wBh3osMcN-hyplXAWSPe0Rhw?e=kIoVdY';
async function fetchExcel() {
const url = 'https://weespfc-my.sharepoint.com/:x:/g/personal/schoolvoetbal_fcweesp_nl/ESHQUaPEePNFqop0hU77d_wBh3osMcN-hyplXAWSPe0Rhw?e=kIoVdY';
try {
const response = await fetch(url);
if (!response.ok) throw new Error("Kan het Excel-bestand niet ophalen");
const response = await fetch(url);
if (!response.ok) throw new Error("Kan het Excel-bestand niet ophalen");
const arrayBuffer = await response.arrayBuffer();
// Lees het Excel-bestand met SheetJS
const workbook = XLSX.read(arrayBuffer, { type: "array" });
const workbook = XLSX.read(arrayBuffer, { type: "array" });
// Selecteer Blad1 en de benodigde cel B2
const worksheet = workbook.Sheets["Blad1"];
const cellAddress = "B2";
const cell = worksheet[cellAddress];
const value = cell ? cell.v : "Geen waarde gevonden";
const worksheet = workbook.Sheets["Blad1"];
const cellAddress = "B2";
const cell = worksheet[cellAddress];
const value = cell ? cell.v : "Geen waarde gevonden";
// Controleer of het element bestaat en werk het bij
const outputElement = document.getElementById('outputCounter');
if (outputElement) {
outputElement.textContent = value;
} else {
console.error("Element met id 'outputCounter' niet gevonden");
}
} catch (error) {
console.error('Fout bij het ophalen van het Excel-bestand:', error);
document.getElementById('outputCounter').textContent = "Fout bij laden";
}
}
const outputElement = document.getElementById('outputCounter');
if (outputElement) {
outputElement.textContent = value;
} else {
console.error("Element met id 'outputCounter' niet gevonden");
}
} catch (error) {
console.error('Fout bij het ophalen van het Excel-bestand:', error);
document.getElementById('outputCounter').textContent = "Fout bij laden";
}
}
// Roep fetchExcel elke 30 seconden opnieuw aan
setInterval(fetchExcel, 30000);
setInterval(fetchExcel, 30000);
Categories:
I have the same question (0)
All responses (
Answers (
