Struct SheetDrawing

Source

pub struct SheetDrawing {
    pub anchors: Vec<DrawingAnchor>,
}

Expand description

A sheet’s drawing (xl/drawings/drawingN.xml, CT_Drawing/root <xdr:wsDr>) — an unbounded list of anchored pictures/charts, matching the schema’s own EG_Anchor choice group repeated maxOccurs="unbounded".

Fields§

§anchors: Vec<DrawingAnchor>

Implementations§

Source §

impl SheetDrawing

Source

pub fn new() -> SheetDrawing

Examples found in repository ?

examples/xlsx_images_and_charts.rs (line 28)

21fn main() -> office_toolkit::Result<()> {
22    let path = output_path("xlsx_images_and_charts.xlsx");
23    let image_bytes = std::fs::read(image_fixture_path())?;
24
25    let picture = SheetPicture::new(image_bytes, PictureFormat::Png).with_name("Test image");
26    let picture_sheet = Sheet::new("Picture")
27        .with_row(Row::new().with_text("The picture is anchored to cell A1:"))
28        .with_drawing(SheetDrawing::new().with_anchor(DrawingAnchor::new(
29            CellAnchorPoint::new(0, 1),
30            CellAnchorPoint::new(2, 6),
31            DrawingObject::Picture(Box::new(picture)),
32        )));
33
34    let chart = SheetChart::new(sample_chart_space()).with_name("Quarterly revenue");
35    let chart_sheet = Sheet::new("Chart")
36        .with_row(Row::new().with_text("A bar chart is anchored below:"))
37        .with_drawing(SheetDrawing::new().with_anchor(DrawingAnchor::new(
38            CellAnchorPoint::new(0, 1),
39            CellAnchorPoint::new(6, 16),
40            DrawingObject::Chart(Box::new(chart)),
41        )));
42
43    let workbook = Workbook::new()
44        .with_sheet(picture_sheet)
45        .with_sheet(chart_sheet);
46    workbook.save_to_file(&path)?;
47    println!("Wrote {}", path.display());
48    Ok(())
49}

Source

pub fn with_anchor(self, anchor: DrawingAnchor) -> SheetDrawing

Examples found in repository ?

examples/xlsx_images_and_charts.rs (lines 28-32)

21fn main() -> office_toolkit::Result<()> {
22    let path = output_path("xlsx_images_and_charts.xlsx");
23    let image_bytes = std::fs::read(image_fixture_path())?;
24
25    let picture = SheetPicture::new(image_bytes, PictureFormat::Png).with_name("Test image");
26    let picture_sheet = Sheet::new("Picture")
27        .with_row(Row::new().with_text("The picture is anchored to cell A1:"))
28        .with_drawing(SheetDrawing::new().with_anchor(DrawingAnchor::new(
29            CellAnchorPoint::new(0, 1),
30            CellAnchorPoint::new(2, 6),
31            DrawingObject::Picture(Box::new(picture)),
32        )));
33
34    let chart = SheetChart::new(sample_chart_space()).with_name("Quarterly revenue");
35    let chart_sheet = Sheet::new("Chart")
36        .with_row(Row::new().with_text("A bar chart is anchored below:"))
37        .with_drawing(SheetDrawing::new().with_anchor(DrawingAnchor::new(
38            CellAnchorPoint::new(0, 1),
39            CellAnchorPoint::new(6, 16),
40            DrawingObject::Chart(Box::new(chart)),
41        )));
42
43    let workbook = Workbook::new()
44        .with_sheet(picture_sheet)
45        .with_sheet(chart_sheet);
46    workbook.save_to_file(&path)?;
47    println!("Wrote {}", path.display());
48    Ok(())
49}