-
Notifications
You must be signed in to change notification settings - Fork 275
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
delete rows cause System.IO.InvalidDataException: SharedFormulaId 3 not found #1474
Comments
Unfortunately we cannot reproduce or figure out what is wrong from this information alone. We would require the workbook and a reproducible code sample that causes the error. |
On Wed, Jun 5, 2024 at 7:01 PM OssianEPPlus ***@***.***> wrote:
Unfortunately we cannot reproduce or figure out what is wrong from this
information alone. We would require the workbook and a reproducible code
sample that causes the error.
—
Reply to this email directly, view it on GitHub
<#1474 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABP5D6QMIG2KMTW7ZQ4CGELZF3V2DAVCNFSM6AAAAABI2NHHNSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBZGUYTKMRTGE>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
using Microsoft.VisualStudio.TestTools.UnitTesting;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using OfficeOpenXml;
using OfficeOpenXml.FormulaParsing.Excel.Functions.MathFunctions;
using OfficeOpenXml.FormulaParsing;
using System.IO;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Information;
using OfficeOpenXml.FormulaParsing.LexicalAnalysis;
namespace EPPlusTest.Issues
{
[TestClass]
public class ShareFormulaError : TestBase
{
[ClassInitialize]
public static void Init(TestContext context)
{
}
[ClassCleanup]
public static void Cleanup()
{
}
[TestInitialize]
public void Initialize()
{
}
[TestMethod]
public void ShareFormulaIDNotFoundError()
{
var filename = "ShareFormulaError.xlsx";
using (var p = OpenPackage(filename))
{
var ws = p.Workbook.Worksheets.First();
ws.DeleteRow(36, 1);
try
{
p.SaveAs("share_formula_error_test.xlsx");
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
//Assert.Fail("Expected no exception, but got: " + ex.Message);
}
}
}
}
}
|
To reproduce this we will require the workbook with the formula you are using as well. |
Thanks, I can reproduce your issue with this workbook. I'll try to provide a fix. |
This issue occurred if you have a shared formula where the first cell has been deleted. I'll provide a fix shortly. |
* Started work on the GetPivotData function * More work on Pivot table calculation * Added support for basic calculation of pivot table formulas * Added support for all pivot functions when calculating a pivot table * Added basic support for pivot table - Show Data As * WIP:More work on pivot calculation - Show value as * WIP:More work on pivot calculation - Show value as * WIP: More work on Show as PercentOf * WIP: Pivot table show value as * WIP:Added dictionary support for fields not in the row/col hierki * WIP:Support for % of Row/Column Total * WIP:Tests * WIP:PercentOf * WIP:ShowAs Running Total * Added new PivotCacheStore * WIP:Pivot Calculation Store * WIP: Added tests for evaluation of pivot table caption filters * WIP:Started on value filters * WIP:Added new PivotCalculationStore * WIP:Pivot Tabel Calculation * WIP:GetPivotData * WIP:Pivot Calculation Percent of * WIP:RunningTotal * WIP:RunningTotal * WIP: ShowAs Running Total * WIP: ShowAs Rank Descending * WIP:Added ShowAsIndex * WIP:ShowAs Index * WIP:Calculation of Date and Numeric Grouping * WIP:Fixed grouping issues for failing tests * WIP: Fixed some tests * WIP:Value Filter in calc * WIP:Added support for all value filter except top-bottom filters * WIP:Added support for Top/Bottom filter * WIP:Added support for Sum and Percent Top/Bottom filters * WIP:Calculate Pivot Table Grouping * WIP:Added support for calculation of date and numeric groupings * WIP:pt.ColumnFields.Add(pt.Fields[Continent]); * WIP:Fixed some failing tests * Fixed copy issue of pivot tables. * WIP:Added tests for date grouping calculation * WIP:More work on calculating numeric groupings in pivot tables * WIP:Fixed some issues with calculaing numeric and date grouping * WIP:Fixed Tests * WIP:Added support sort. * WIP:Started work on pivot table field formulas calculation * WIP:Calculated pivot fields * WIP:Calculation of pivot fields * WIP:Fixed reading of pivot records. Fixed a few bugs * WIP:Fixed cache comparer to match on strings. Fixed issue with calculating grouped columns. Started work on slicer filtering * WIP:Pivot table slicer filters in calculation * WIP:Work on Pivot Table Calculation * WIP:Fixed compile error. Removed tests * WIP:Fixed failing tests * Fixed some issues and tests in the pivot calculation. * Set ExcelPivotTable.GetPivotData to public. The GetPivotData method now calculates a pivottable if it has not been calculated. Fixed some test * Fixed Text replace issue * Added more tests for multiple data fields of the same pivot field * Added CalculatedData property * Added tests * Fixes issue #1421 * Added new Property CalculatedItems. Removed redundant property ExcelPivotTableField.CacheField * Added calculation of multiple subtotals * Added support for muliple subtotals on row/column fields * Added new interface for class ExcelPivotTable.CalculatedData * Added new aggregation to speed up performance. * Fixed an issue with subtotal items. Added new tests for refreshing the cache * Fixed some issues with aggregated keys on row/columns. Added tests. * Feature/textsplit func (#1426) * Added excel function TEXTSPLIT * TextBefore excel function * TetxtBefore workbook test * TEXTAFTER Excel function * MMULT excel function added * TEXTBEFORE Now accepts ranges as arg * TEXTAFTER function takes range as arg * MINVERSER excel function started * Added mdeterm, munit & more * Fixed issues with new excel functions * split some code into other functions * fixed null ref in mmult * Feature/transpose (#1420) * Added test case for transposing data table * Read transposed data from worksheet to DataTable * Added exporting from tranposed worksheet to text and collection * export json from transposed. * Export text async from transposed. * Transpse Range copy * Load from dictionary to transposed * Load from Array Transposed * Load collection to transposed progess * Load from collection to transposed * Load from array transposed * Load data reader to transposed * Fixed test issue with transpose * changed name of some variables * fixed variable names * Feature/html icon sets (#1425) * Adding start of iconset exports * Encoding wrong * Fixed several bugs added functional encoding * added viewbox * Added functional css for one icon * Added easy set handling and start of shouldapply icon * Added several icons * Ensured scalability, added several symbols * Added all remaining icons. Made 4 and 5 iconsets work. * Attempt at hex handling * Resolved multiple bugs. Added better set reference * Fixed percentile for iconsets. PercentRank.Inc appears to be the function * Fixes issue #1421 (#1422) * Cleanup and bugfix * Fix exception message in automapping in ToCollection (#1423) * Added fixed issues * Fixed test added fixed issues * Cleanup * Fixed comment with info --------- Co-authored-by: Jan Källman <[email protected]> * Fixed some failing tests * Minor refactoring * Fixed async difference (#1438) * Removed commented out code. Updated headers to version 7.2 * Made testbase unicode * adding tests unfinished * Feature/html databars (#1439) * Adding start of iconset exports * Encoding wrong * Fixed several bugs added functional encoding * added viewbox * Added functional css for one icon * Added easy set handling and start of shouldapply icon * Added several icons * Ensured scalability, added several symbols * Added all remaining icons. Made 4 and 5 iconsets work. * Attempt at hex handling * Resolved multiple bugs. Added better set reference * Fixed percentile for iconsets. PercentRank.Inc appears to be the function * Fixes issue #1421 (#1422) * Cleanup and bugfix * Fix exception message in automapping in ToCollection (#1423) * Added fixed issues * Fixed test added fixed issues * Added databar functionality. Likely bugged. * Added databar bugfixes * Ensured axis position and variable clarity * Added support for formula, percentile and num * added percent * Corrected test-cases * Fixed height issue * Merge fix * Prevented potential name conflict * Caching iconsets/better names * Adjusted databar names * Cleanup and test --------- Co-authored-by: Jan Källman <[email protected]> * Feature/fixed width (#1419) * LoadFromCollection/new logic for member sort order (#1296) * wip * wip2 * wip * Wip 2 * wip * First version of LoadFromCollection after refactoring * wip 3 * WIP 3 * Adjusted CreatePropertyGetter so it supports inheriting classes to * Removed uncommented code --------- Co-authored-by: swmal <{ID}+username}@users.noreply.github.com> * Feature/cf html exporter (#1349) * New css and html connection based on CF. Poor performance * Added Quadtree fetched CF-dictionary * First solution functional on single cells * Added support for more types and start of class diagraAdded support for more types and start of class diagramm * Temp draft save * Added endsWith * Added several styles to dxfCss * Fixed underline and strike through but can't stop strikethrough double * Staticified some caches * Added wrapper * Broke out stylecache from css adjusted names of css styles to stack in right specificity order and fixed bug in get collection from range * Completely removed stylecache from writers * Initial creation of new writers * Ensured translator and new writer can handle fills * Added TranslatorBase fill font and translatorContext logic * Added border and textFormat translators * Simplified rangeTranslator and added sharedClasses * Added stylecache * Added picture translator * Properties and new if-case * Added stylechecker class * Translators * Start of adding dxf * Generic style draft * First draft of styleContracts * New draft applying interfaces instead * Adding of color * color fixes * Color added * Added initial border * Renamed interface style and re-introduced merged cells * Attempt at delegates * New handling of intersect detection * Simplification of conditionalFormatting * Started adding tables. Alignment missing on range * Added start of table writer replacement * Added table support * Fixed bugs for table in range. In process of fixing tableExporter * minor fix * Added async writing to new methods * Async support and table/range unification * Finialized unification * Fixes fill when no fill was present * Fixed multiple bugs to ensure all tests pass * Cleanup and deletion of old files * Html alternative draftHtml * Half-implemented header row * Added htmlElement to headerRow * Function breakout and start of renderTablerows * Fixed minor formatting htmlsync bugs * Simplified writer fixed html formatting of images in cells * Start of joint functions for html tables and ranges * Moved range over to standard functions. Removed unused functions * Performance fixes using hashes * Minor improvements * Generalized sync async html and removed unused functions * Cleaned up and unified functionality * Fixed CF and hyperlink bugs. Removed classDiagram * Fixed hyperlinks and unnecesary whitespaces after * Fixed not adding whitespaces where appropriate * Added containsErrors cf * Added cf_Between shouldApply with edge cases and missmatches * Added fix for calculatedFormula issues * Fixed cell value set bug and simplified between * Added simplifications, bug fix and test * Added Averages to exporter/shouldApply * Added should apply for timeGroup between greater than and less than * Added standardDeviation should apply * Added unique shouldApply * Added TopBottom function * Added basic twoColorScale implementation * Ensured range functionality on headers and easier implementation of future special cases * Added faulty 3 color * Ensured Threerange is correct when values non-linear * Started adding databar * Half-made databar * Added better chaching of cellValues * removed empty line * Ensured removal of tempExport Data. Positive databar implementation * further partial databar implementation * Fixed text-alignment and color scale dissapear issues * Adding Databar functionality * Added databar border and moved to css * Added axis position start * Added variable axis position in html exporter for databars * Added horizontal and vertical text-alignment to databars * Added databar solution to header * Start of shared formulas for cfs * Added dynamically calculated formulas to cfs * Resolved Token list not clearing on between bug * Simplification of css data gathering and cleanup * Added highly innefficent colName solution * Fixed notbetween handling * Added null-handling for cellIs shouldApply functions * Fixes for text functions * Fixes for end users * Fixes issue #1292 * Bug/s608 first sheet deletion (#1294) * Beggining of solution * Simplified solution. Added tests and exception * Cleanup * Fixes issue #1298 * Added test * Fixed test * Fixes issue #1298 (#1299) * Fixes issue #1298 * Added test * Fixed test * EPPlus version 7.0.9 * Fixes issue #1302 * Fixes issue 1304 * Resolved null-reference bugs and spell-checked "extentions" * Ensured top/bottom can handle error and other values correctly * Removed stale exception * Fixes issue #1308 * Fixes #1313. Better handling of defined names and encode ExcelNamedRange.NameValue property on save * Ensured shouldApply as appropriate * Added new test class * Bugfixing * Bug/s615 data validation read (#1307) * Added new test removed issue test * Added readwrite to test for confirmation * Added fixed issues * Secured DataValidation reading. Fixed i1312 * Non-working strict solution * Resolved dataValidation read issues. Added docs * Cleanup and commenting * Make test happy in production --------- Co-authored-by: Jan Källman <[email protected]> * Fixes issue #1320 (#1322) * Bug/issue1321 (#1324) * Fixes issue #1320 * Fixes issue #1321 * Added CellStore Test * #1329 - adjusted ActiveTab when moving worksheets * #1327 - EPPlus removed all styling when setting a Table's CalculatedFormula to an empty string * #1327 - fixed failing unit test, added ClearFormulas call * #1332 - Intersect operator was replaced with 'isc' when copying cells (#1333) * #1332 - Intersect operator was replaced with 'isc' when copying cells * #1332 - removed the added static DefaultPreserveWhiteSpace from SourceCodeTokenizer * Fixes issue #1338 * Updated fixed issues * Fixed text contains error * Fixes issue #1341 * Bug/issue1338 (#1340) * Fixes issue #1338 * Updated fixed issues * Colorscale bugfix * Added fix for two colorscale as well * EPPlus version 7.0.10 * Fixes #1343. Writing and loading pivot table attribute on CFs (#1344) * Fixes #1343. Writing and loading pivot table attribute on CFs * Added docs * Bug/s635 insert row (#1346) * Fixes #1345 fixed read exception faulty while loop * Added template-free test * fixed LastToken and added docs --------- Co-authored-by: Jan Källman <[email protected]> * Fixed databars, table alignment, flagging conditionalFormatting as optional * Cleanup comments usings and top of file * Removal of databars + cleanup --------- Co-authored-by: JanKallman <[email protected]> Co-authored-by: swmal <[email protected]> * pseudocode for fixed width * Pseudocode for reading fixed width * Emergency fill fix (#1357) * Fixed Width text reading. * Feature/rich text (#1352) * Fixes issue #1292 * Bug/s608 first sheet deletion (#1294) * Beggining of solution * Simplified solution. Added tests and exception * Cleanup * Fixes issue #1298 * Added test * Fixed test * Fixes issue #1298 (#1299) * Fixes issue #1298 * Added test * Fixed test * EPPlus version 7.0.9 * Fixes issue #1302 * Fixes issue 1304 * Fixes issue #1308 * Fixes #1313. Better handling of defined names and encode ExcelNamedRange.NameValue property on save * Added new test class * Bug/s615 data validation read (#1307) * Added new test removed issue test * Added readwrite to test for confirmation * Added fixed issues * Secured DataValidation reading. Fixed i1312 * Non-working strict solution * Resolved dataValidation read issues. Added docs * Cleanup and commenting * Make test happy in production --------- Co-authored-by: Jan Källman <[email protected]> * Fixes issue #1320 (#1322) * Bug/issue1321 (#1324) * Fixes issue #1320 * Fixes issue #1321 * Added CellStore Test * #1329 - adjusted ActiveTab when moving worksheets * #1327 - EPPlus removed all styling when setting a Table's CalculatedFormula to an empty string * Progress on RichText optmimzation. * Added more tests * Fixed color auto property not being read properly * #1327 - fixed failing unit test, added ClearFormulas call * Deleted old files and fixing tests. * #1332 - Intersect operator was replaced with 'isc' when copying cells (#1333) * #1332 - Intersect operator was replaced with 'isc' when copying cells * #1332 - removed the added static DefaultPreserveWhiteSpace from SourceCodeTokenizer * Fixed some more tests not passing. * Updated a test. * Fixes issue #1338 * Updated fixed issues * Fixes issue #1341 * Bug/issue1338 (#1340) * Fixes issue #1338 * Updated fixed issues * EPPlus version 7.0.10 * Fixed rich text for more tests. * Fixes issue #1335 * Fixes #1343. Writing and loading pivot table attribute on CFs (#1344) * Fixes #1343. Writing and loading pivot table attribute on CFs * Added docs * Bug/s635 insert row (#1346) * Fixes #1345 fixed read exception faulty while loop * Added template-free test * fixed LastToken and added docs --------- Co-authored-by: Jan Källman <[email protected]> * Fixed richtext issues. * Fixed issue when having multiple spaces is a intersect operator and use keep whitespaces * Fixed issue with rich text comments not being saved & rich text attrobutes not being copied. * Cleaned up richtexttests * Added copy worksheet test for richtext * Removed RichTextAttributes and using properties again. * Moved files and deleted new folder. * Fixed GetIndexColor - as it has been moved to Styles * Fixed some issues with failed tests * Ensured mergedcells border can be null * Fixed remove in ExcelParagraphCollection. * Removed commented code. --------- Co-authored-by: JanKallman <[email protected]> Co-authored-by: OssianEPPlus <[email protected]> Co-authored-by: swmal <[email protected]> Co-authored-by: Ossian Edström <[email protected]> * Fixed a few bugs in the new html export * Progress on Reading fixed width column text files. * Fixed return range * Changed output path in TableExporterTests * Changed so user now need to set the column lengths in exceltextformat instead of passing it to the read method. * Started working on support for reading fixed width text files from position. * Read fixed width files with post start positions Read specified columns * Read fixed width from fileinfo and specify conditions for readin rows with Func * Started work on saving fixed width text. * Added test and exportconditionalformatting.xlsx in the workbooks folder * Save fixed width files * Save fixed width file progress * Refactoring reading and saving fixed width text files. Now has a properties for each column. * Fixed duplicates ignore case * Made priority work by inversing Order * Fixed Width test reading and saving. * Fixed sometimes empty _baseFormula * Cleanup and bugfix. Fixed cf style read, added comments, ensured priority reads correctly * Fixed breaking change * #1301 - initial implementation of NumberFormatProvider in LoadFromCollection (#1381) Co-authored-by: swmal <{ID}+username}@users.noreply.github.com> * Fixed failing test s312 * Support for excluding rows and columns when saving CSV * Added xml comments. Fixed issues with failing tests. * Added name property to fixed width reading. * Test for example * changed named of variables for clarity & updated xml comments. * Load from text to transpose, csv & fixed width * Fixed Text width transpose test * Fixes issue #1421 (#1422) * Fix exception message in automapping in ToCollection (#1423) * Fix #1416 nullable members in LoadFromCollection() (#1417) * Fix #1416 nullable members in FromCollection * Replaced issue test with more appropriate thourough test * Added comments and ensuring headers * EPPlus version 7.1.2 * Updated release date in version history * Fixed isses wth fixed wiidth * Changed how reading and saving using positions in fixed width files. * fixed small reading fixed width issue * added validation on position values. * DataValidation lists can now read showDropDown=0 (#1430) * DataValidation lists can now read showDropDown=0 * Added fixed issues * Fixed issues regarding usability * Fixed cultureInfo issue in test * Added xml documentations * Fixes issue #1435 - Name indexer on group drawings did not work. * Ensured correct read write of custom iconset and gte (#1433) * build: Use central package management (#1424) * build: Use central package management * build: Fix `DefineConstants` value for test project --------- Co-authored-by: Jan Källman <[email protected]> * Fixed issues with csv exporting * Bug/i1423 (#1437) * Ensured clearing * Failing test for remove. Cannot remove individual cells * Functional non-optimized rangeDictionary fix * Added ClearRows method. Resolved Edge case * Simplified * Compressed and simplified further * Cleanup * Added fixed issues * cleaned up comment * Fixed some faing tests and removed some other tests * FIxed some tests. Refactoring names * ColumnLengths fix * fixed width can now take -1 as last parameter to read until eol. * Minor refactoring and added new tests * Fixed some issues with fixed width reading, added async saving. --------- Co-authored-by: Mats Alm <[email protected]> Co-authored-by: swmal <{ID}+username}@users.noreply.github.com> Co-authored-by: OssianEPPlus <[email protected]> Co-authored-by: JanKallman <[email protected]> Co-authored-by: Ossian Edström <[email protected]> Co-authored-by: Antonis Kordatzakis <[email protected]> * Added calculate to tests * WIP:Added PivotShowAsDifference * Expanded tests * Further tests * Basefield fix * Fixed several warnings * Fixed ShowAsDifferenceOf calculation * WIP:Redesign ShowAsDifference * Some fixed on ShowAs-Difference * Fix/s671 cf in pivot (#1451) * Fixed several warnings * Fixed reading and writing of pivot CFs * WIP:Changed ShowAs Running Total calculation * Fixed test text files to copy if newer on build * Fixed merge issue * Redesigned ShowAs-Running Total calculations.Added more tests * Implemented LET function (#1459) * Added a test for LET and started work on tokenizer * work on let function * First implementation of LET function * Wip * More work on LET function * Intial LET function implementation * Added unit test for LET and small performance improvement in RpnFormulaExecution for LET * Removed unnecessary using statement and empty if-statement --------- Co-authored-by: swmal <{ID}+username}@users.noreply.github.com> * Fix/cf advanced theme colors (#1460) * Ensured theme colors work with cfs and html export * Fixed assert for test * Minor comment fix * Removed old comment * Fixes for pr comments * Removed uncommented code * Fix/removing warnings (#1449) * More warning fixes * Added xml comments and removed unused files * Make rangeBaseAsync actually async * Fix overrides and 3.5 optional comments * added fixes * Fixed skiprow bug * Set several public classes as internal in the formula parser, that should not be exposed. --------- Co-authored-by: JanKallman <[email protected]> * Added new properties FirstValueCell, LastValueCell and DimensionByValue properties to ExcelWorksheet * Added text to fixedissues.md * Removed out-commented code * Changed Text function back to public * Transpose tests and table column bugfix (#1456) * Transpose tests * Fixed table column bug * Ensured column counting is correct * Fixed table column names * Ensured coherence with previous behaviour * Added alternative to not overwrite empty cells when overwriting column names * Unified option * Clearer names. * Ammended names and comment for clarity * Removed deleted namespaces * Added fixed issues * Added new overload to GetValue * Fixed some issues with Pivot Table calculations * Feature/copy drawings (#1472) * copyDrawings progress * CopyCharts are working now... * Copy drawings * copy control vml * copy drawing controls progress * Copy slicers & fixing copy issues. * Fixed issues with copying drawings * renamed some variables * Refactor copy drawings code * copy drawing control * Groupshape copy progress. * fixed copy slicer issue * fixed smaller issues with slicer copy * Fixed settings new name to copied drawings and tests * Pivot table slicer progress * Fixed slicer issues. * Copy drawings on ranges * Fixes issue #1474 and #1476 * fixed issue #1475 (#1479) * fixed issue #1475 * removed unnecesry usings * Fixed meta data for #Spill! errors * Renamed method * Removed incorrect . * Changed md file * Update fixedissues.md * Added fixed issues * Added fixed issues2 * Fixes issue #1483, #1486. Fixed an issue with DimensionByValue. --------- Co-authored-by: AdrianEPPlus <[email protected]> Co-authored-by: OssianEPPlus <[email protected]> Co-authored-by: Ossian Edström <[email protected]> Co-authored-by: Mats Alm <[email protected]> Co-authored-by: swmal <{ID}+username}@users.noreply.github.com> Co-authored-by: Antonis Kordatzakis <[email protected]>
EPPlus usage
Personal use
Environment
Windows
Epplus version
7.1.3
Spreadsheet application
Excel
Description
my program load a template file, fill data , where days of this month is not 31, delete some rows.
when call Package.SaveAs(..),
I got exception like follows:
System.IO.InvalidDataException: SharedFormulaId 3 not found on Worksheet 彩色 cell Z36, SharedFormulas Count 7
於 OfficeOpenXml.Core.Worksheet.XmlWriter.WorksheetXmlWriter.UpdateRowCellData(StreamWriter sw, String prefix)
於 OfficeOpenXml.Core.Worksheet.XmlWriter.WorksheetXmlWriter.WriteNodes(StreamWriter sw, String xml, Int32& startOfNode, Int32& endOfNode)
於 OfficeOpenXml.ExcelWorksheet.SaveXml(Stream stream)
於 OfficeOpenXml.ExcelWorksheet.SaveHandler(ZipOutputStream stream, CompressionLevel compressionLevel, String fileName)
於 OfficeOpenXml.Packaging.ZipPackagePart.WriteZip(ZipOutputStream os)
於 OfficeOpenXml.Packaging.ZipPackage.Save(Stream stream)
於 OfficeOpenXml.ExcelPackage.Save()
於 OfficeOpenXml.ExcelPackage.SaveAs(Stream OutputStream)
The text was updated successfully, but these errors were encountered: