Kataloğumuz
body { font-family: Arial, sans-serif; }
.page {
width: 794px;
min-height: 1123px;
padding: 20px;
box-sizing: border-box;
page-break-after: always;
}
.grid {
display: grid;
grid-template-columns: 1fr 1fr;
gap: 20px;
}
.card {
border: 1px solid #ddd;
padding: 10px;
}
.title { font-weight: bold; font-size: 14px; }
.small { font-size: 12px; color: #555; }
.price { font-weight: bold; margin-top: 5px; }
const excelFile = "katalog.xls"; // <-- Excel dosya yolu
fetch(excelFile)
.then(res => res.arrayBuffer())
.then(data => {
const workbook = XLSX.read(data, { type: "array" });
const sheet = workbook.Sheets[workbook.SheetNames[0]];
const json = XLSX.utils.sheet_to_json(sheet);
const container = document.getElementById("catalog");
let page, grid;
json.forEach((item, i) => {
if (i % 8 === 0) {
page = document.createElement("div");
page.className = "page";
const header = document.createElement("h2");
header.innerText = "KayısıCenter 2026 Toptan Ürün Kataloğu";
page.appendChild(header);
grid = document.createElement("div");
grid.className = "grid";
page.appendChild(grid);
container.appendChild(page);
}
const card = document.createElement("div");
card.className = "card";
card.innerHTML = `
${item["URUN-ADI"]}
Stok Kodu: ${item["STOK-KODU"]}
Miktar: ${item["MIKTARI"]} Kg
Fiyat: ${Number(item["FIYAT"]).toFixed(2)} ₺
`;
grid.appendChild(card);
});
setTimeout(createPDF, 800);
});
async function createPDF() {
const { jsPDF } = window.jspdf;
const pdf = new jsPDF("p", "pt", "a4");
const pages = document.querySelectorAll(".page");
for (let p = 0; p < pages.length; p++) {
const canvas = await html2canvas(pages[p]);
const img = canvas.toDataURL("image/png");
if (p > 0) pdf.addPage();
pdf.addImage(img, "PNG", 0, 0, 595, 842);
}
pdf.save("KayisiCenter-Toptan-Katalog.pdf");
}