Skip to main content

SheetOptions

Struct SheetOptions 

Source
pub struct SheetOptions {
    pub name: String,
    pub columns: Vec<ColumnDef>,
    pub write: WriteOptions,
    pub computed: Vec<(ColumnDef, CellExpr)>,
    pub transforms: Vec<(String, CellExpr)>,
}
Expand description

单个工作表的配置

Fields§

§name: String§columns: Vec<ColumnDef>

列定义(表头、别名、宽度、格式、图片列)

§write: WriteOptions§computed: Vec<(ColumnDef, CellExpr)>

计算列:导出时按表达式追加到末尾

§transforms: Vec<(String, CellExpr)>

列改写:按表头匹配,导出时用表达式替换该列的值

Implementations§

Source§

impl SheetOptions

Source

pub fn new(name: impl Into<String>) -> Self

Source

pub fn columns<I>(self, columns: I) -> Self
where I: IntoIterator<Item = ColumnDef>,

Source

pub fn write_options(self, write: WriteOptions) -> Self

Source

pub fn computed<F>(self, def: ColumnDef, expr: F) -> Self
where F: for<'a> Fn(&RowValues<'a>) -> CellValue + Send + Sync + 'static,

追加一个计算列(导出时按表达式算出,无需模型里有对应字段)

ⓘ
use fast_excel::{CellValue, ColumnDef, SheetOptions, funcs};
let sheet = SheetOptions::new("明细")
    .columns(ProductRow::columns())
    .computed(ColumnDef::new("全名"), |row| {
        CellValue::Text(funcs::concat(&[&row.text("姓"), &row.text("名")]))
    });
Source

pub fn transform<F>(self, header: impl Into<String>, expr: F) -> Self
where F: for<'a> Fn(&RowValues<'a>) -> CellValue + Send + Sync + 'static,

改写已有列的值(按表头匹配;表达式拿到的是本行其它列的原始值)

Source

pub fn effective_columns(&self) -> Vec<ColumnDef>

实际写出的列 = 基础列 + 追加的计算列

Source

pub fn eval_row(&self, cells: Vec<CellValue>) -> Vec<CellValue>

应用列表达式:先按表头改写,再追加计算列

Trait Implementations§

Source§

impl Clone for SheetOptions

Source§

fn clone(&self) -> Self

Returns a duplicate of the value. Read more
1.0.0 (const: unstable) · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more
Source§

impl Debug for SheetOptions

Source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more
Source§

impl Default for SheetOptions

Source§

fn default() -> Self

Returns the “default value” for a type. Read more

Auto Trait Implementations§

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = !

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, !>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.