pub struct ExcelReader { /* private fields */ }Expand description
xlsx 读取器(可同时解析多个工作表;每次 stream 都是独立的流式读取)
Implementations§
Source§impl ExcelReader
impl ExcelReader
Sourcepub fn from_bytes(bytes: Vec<u8>) -> Result<Self>
pub fn from_bytes(bytes: Vec<u8>) -> Result<Self>
以内存字节打开(HTTP 上传的 multipart 场景)
Sourcepub fn from_source(source: ZipSource) -> Result<Self>
pub fn from_source(source: ZipSource) -> Result<Self>
复用已有数据源
pub fn source(&self) -> &ZipSource
pub fn sheets(&self) -> &[SheetInfo]
pub fn sheet_names(&self) -> Vec<String>
pub fn date_1904(&self) -> bool
Sourcepub fn stream(
&self,
selector: SheetSelector,
defs: &[ColumnDef],
options: ReadOptions,
) -> Result<SheetStream>
pub fn stream( &self, selector: SheetSelector, defs: &[ColumnDef], options: ReadOptions, ) -> Result<SheetStream>
打开一个工作表的行流(单个 sheet)
Sourcepub fn stream_sheet(
&self,
sheet: &SheetInfo,
defs: &[ColumnDef],
options: ReadOptions,
) -> Result<SheetStream>
pub fn stream_sheet( &self, sheet: &SheetInfo, defs: &[ColumnDef], options: ReadOptions, ) -> Result<SheetStream>
打开指定工作表的行流
Sourcepub fn analyze_header(
&self,
selector: &SheetSelector,
defs: &[ColumnDef],
options: ReadOptions,
) -> Result<HeaderAnalysis>
pub fn analyze_header( &self, selector: &SheetSelector, defs: &[ColumnDef], options: ReadOptions, ) -> Result<HeaderAnalysis>
只做表头自适应分析(不消费数据,供“导入预检“接口使用)
Sourcepub fn analyze_all_headers(
&self,
defs: &[ColumnDef],
options: ReadOptions,
) -> Result<Vec<(String, HeaderAnalysis)>>
pub fn analyze_all_headers( &self, defs: &[ColumnDef], options: ReadOptions, ) -> Result<Vec<(String, HeaderAnalysis)>>
读取所有工作表的表头分析(多 sheet 预检)
Sourcepub fn merge_ranges(&self, selector: &SheetSelector) -> Result<Vec<MergeRange>>
pub fn merge_ranges(&self, selector: &SheetSelector) -> Result<Vec<MergeRange>>
读取指定(可多个)工作表的合并区域(只查询,不做值回填)
需要值回填时改用 ReadOptions::with_merges 走 ExcelReader::stream。
Sourcepub fn hyperlinks(&self, selector: &SheetSelector) -> Result<Vec<Hyperlink>>
pub fn hyperlinks(&self, selector: &SheetSelector) -> Result<Vec<Hyperlink>>
读取指定(可多个)工作表的超链接
Sourcepub fn validations(
&self,
selector: &SheetSelector,
) -> Result<Vec<DataValidation>>
pub fn validations( &self, selector: &SheetSelector, ) -> Result<Vec<DataValidation>>
读取指定(可多个)工作表的数据验证(下拉 / 数值区间)
Sourcepub fn conditional_formats(
&self,
selector: &SheetSelector,
) -> Result<Vec<ConditionalFormat>>
pub fn conditional_formats( &self, selector: &SheetSelector, ) -> Result<Vec<ConditionalFormat>>
读取指定(可多个)工作表的条件格式
Sourcepub fn read_dynamic(
&self,
selector: &SheetSelector,
options: ReadOptions,
) -> Result<(Vec<String>, Vec<DynamicRow>)>
pub fn read_dynamic( &self, selector: &SheetSelector, options: ReadOptions, ) -> Result<(Vec<String>, Vec<DynamicRow>)>
动态读取整表(无实体):返回 (表头, 每行 表头→值)
等价于 stream(selector, &[], options) + DynamicRow::from_row,
用于「没有实体、前端直接拿表头与内容」的场景。
Auto Trait Implementations§
impl Freeze for ExcelReader
impl RefUnwindSafe for ExcelReader
impl Send for ExcelReader
impl Sync for ExcelReader
impl Unpin for ExcelReader
impl UnsafeUnpin for ExcelReader
impl UnwindSafe for ExcelReader
Blanket Implementations§
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more