The invention discloses an Excel report automatic conversion and rendering method,
system, device and medium, and relates to the field of
data processing,
visualization and document generation, the method comprises the following steps: adopting an intelligent Excel analysis engine to automatically analyze Excel file structure features, and selecting a most suitable analyzer to analyze an Excel file; based on an xlsx
library and a data structured conversion mechanism, performing
data processing on the analyzed Excel file, and constructing a structured
data model; based on a dynamic component of React, constructing different types of visual generation components according to the structured
data model, and determining a
layout framework; and based on a dynamic component and a structured
data model of React, dynamically loading and rendering the visual content in the
layout framework by adopting a
headless browser technology, configuring browser parameters suitable for generating a PDF format, and displaying a PDF document according to the browser parameters. The method has the advantages of high-flexibility Excel analysis capability, strong
data processing capability, rich visual expressive force, high-quality PDF rendering and efficient
batch processing capability.