Aspose.Cells FOSS
Getting Started
Quickstart

Quickstart

Buat Buku Kerja

Buat buku kerja baru, tulis nilai ke sel, dan simpan ke XLSX:

import { Workbook } from "@aspose/cells";

const workbook = new Workbook();
const worksheet = workbook.worksheets[0]!;

worksheet.putValue("A1", "Product");
worksheet.putValue("B1", "Revenue");
worksheet.putValue("A2", "Widget");
worksheet.putValue("B2", 42000);
worksheet.putValue("A3", "Gadget");
worksheet.putValue("B3", 31500);

await workbook.save("report.xlsx");

Mengisi Buku Kerja yang Sudah Ada

Buka file XLSX yang ada dan baca nilai sel:

const workbook = await Workbook.load(“report.xlsx”); const worksheet = workbook.worksheets[0]!;

const product = worksheet.getCell(0, 0)?.value; const revenue = worksheet.getCell(0, 1)?.value; console.log(${product}: ${revenue});


## Gunakan Styling

Buatlah sebuah `Style` obyek dan menerapkan pengaturan font pada sel:

```typescript
import { Workbook, Style } from "@aspose/cells";

const workbook = new Workbook();
const worksheet = workbook.worksheets[0]!;

const style = new Style();
style.setFontName("Arial");
style.setFontSize(14);
style.setBold(true);
style.setFontColor("FF0000");

const cell = worksheet.getCell2("A1");
cell.putValue("Styled Text");
cell.setStyle(style);

await workbook.save("styled.xlsx");

Ekspor ke Berbagai Format

Menyimpan buku kerja ke CSV, JSON, Markdown, dan HTML:

const workbook = new Workbook(); const worksheet = workbook.worksheets[0]!; worksheet.putValue(“A1”, “Name”); worksheet.putValue(“B1”, “Age”); worksheet.putValue(“A2”, “Alice”); worksheet.putValue(“B2”, 25);

await workbook.save(“data.xlsx”); await workbook.save(“data.csv”); await workbook.save(“data.json”); await workbook.save(“data.md”);


## Langkah-langkah Selanjutnya

- [Panduan Pengembang](https://docs.aspose.org/cells/typescript/developer-guide/) dokumentasi fitur rinci
- [Referensi API](https://reference.aspose.org/cells/typescript/) referensi kelas dan metode

## See Also

- [Aspose.Cells — Enterprise Documentation](https://docs.aspose.com/cells/)
 Bahasa Indonesia