search

qax-os / excelize

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
https://xuri.me/excelize
BSD 3-Clause "New" or "Revised" License
17.64k stars 1.69k forks source link

Is Streamwriter can set ConditionalFormatOptions? #1832

Open ShowerBandV opened 4 months ago

ShowerBandV commented 4 months ago

Hello xuri,I would like to know which scenarios are supported in streamwriter,as I know streamwriter api can not use with non-stream api，so I'm worry about if we replace our code with streamwriter,our system may lose some functionality

xuri commented 4 months ago

Thanks for your issue. There are two kinds of functions in the excelize library: normal mode functions and stream mode functions. The stream mode function is used to generate a worksheet with the amount of data in lower resource usage. However, this mode does not have a one-to-one correspondence with all functions in the normal mode, it just implements some commonly used functions, and we will add more stream mode functions in the future. This library doesn't support creating a conditional format in stream mode currently, so please set the cell data with the normal mode function SetConditionalFormat.

ShowerBandV commented 4 months ago

Thanks for your issue. There are two kinds of functions in the excelize library: normal mode functions and stream mode functions. The stream mode function is used to generate a worksheet with the amount of data in lower resource usage. However, this mode does not have a one-to-one correspondence with all functions in the normal mode, it just implements some commonly used functions, and we will add more stream mode functions in the future. This library doesn't support creating a conditional format in stream mode currently, so please set the cell data with the normal mode function SetConditionalFormat.

thanks

ShowerBandV commented 2 months ago

Thanks for your issue. There are two kinds of functions in the excelize library: normal mode functions and stream mode functions. The stream mode function is used to generate a worksheet with the amount of data in lower resource usage. However, this mode does not have a one-to-one correspondence with all functions in the normal mode, it just implements some commonly used functions, and we will add more stream mode functions in the future. This library doesn't support creating a conditional format in stream mode currently, so please set the cell data with the normal mode function SetConditionalFormat.

Is Hyperlink supported by streamwriter?