'ZipArchiveEntry.Open()' synchronously blocks. Await 'ZipArchiveEntry.OpenAsync(CancellationToken)' instead. (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca1849)

Use Task.ConfigureAwait(false) if the current SynchronizationContext is not needed (https://github.com/meziantou/Meziantou.Analyzer/blob/main/docs/Rules/MA0004.md)

Blocking call 'entry.Open' can cause deadlocks in async code. Use 'OpenAsync' instead. (https://github.com/semihokur/AsyncFixer#asyncfixer02)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Loop should be simplified by calling Select(sheet => sheet.SheetId))

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Remove this unread private field '_rowNumber' or refactor the code to use its value.

'XlsReader.GetAsyncEnumerator(CancellationToken)' synchronously blocks. Await 'XlsReader.GetAsyncEnumeratorAsync(CancellationToken)' instead. (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca1849)

Call System.IDisposable.Dispose on object created by 'new Enumerator(this, _sheets[_current].Offset, ct)' before all references to it are out of scope (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca2000)

Use 'ArgumentOutOfRangeException.ThrowIfNegative' instead of explicitly throwing a new exception instance (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca1512)

'XlsbSheetWriter' contains field '_records' that is of IDisposable type 'BiffBuffer', but it is never disposed. Change the Dispose method on 'XlsbSheetWriter' to call Close or Dispose on this field. (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca2213)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Call System.IDisposable.Dispose on object created by 'new XlsbRowWriter(this, _records, _date1904)' before all references to it are out of scope (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca2000)

Method 'ExcelReader.Core.Parser.Internal.ExcelEnumerable<T, TReader, TEnumerator>.AsyncEnumerator.AsyncEnumerator(TReader, ExcelReader.Core.Parser.Internal.TypeMapInfo<T>, System.StringComparer, ExcelReader.Core.Parser.HeaderNormalization, int, System.Threading.CancellationToken, System.IFormatProvider)' should take CancellationToken as the last parameter (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca1068)

Use recommended dispose pattern to ensure that object created by 'new(path, FileMode.Open, FileAccess.Read, FileShare.Read, bufferSize: 65536,' is disposed on all paths. If possible, wrap the creation within a 'using' statement or a 'using' declaration. Otherwise, use a try-finally pattern, with a dedicated local variable declared before the try region and an unconditional Dispose invocation on non-null value in the 'finally' region, say 'x?.Dispose()'. If the object is explicitly disposed within the try region or the dispose ownership is transfered to another object or method, assign 'null' to the local variable just after such an operation to prevent double dispose in 'finally'. (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca2000)

Remove this unread private field '_rowNumber' or refactor the code to use its value.

Blocking call 'entry.Open' can cause deadlocks in async code. Use 'OpenAsync' instead. (https://github.com/semihokur/AsyncFixer#asyncfixer02)

Blocking call 'entry.Open' can cause deadlocks in async code. Use 'OpenAsync' instead. (https://github.com/semihokur/AsyncFixer#asyncfixer02)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Loop should be simplified by calling Select(sheet => sheet.SheetId))

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Consider using CollectionsMarshal.AsSpan() instead of foreach with List<ExcelReader.Core.Writer.XlsbSheetWriter> (https://github.com/NetFabric/NetFabric.Hyperlinq.Analyzer/tree/master/docs/reference/HLQ012_UseCollectionsMarshalAsSpanAnalyzer.md)

Method 'ExcelReader.Core.Parser.Internal.ExcelEnumerable<T, TReader, TEnumerator>.AsyncEnumerator.AsyncEnumerator(TReader, ExcelReader.Core.Parser.Internal.TypeMapInfo<T>, System.StringComparer, ExcelReader.Core.Parser.HeaderNormalization, int, System.Threading.CancellationToken, System.IFormatProvider)' should take CancellationToken as the last parameter (https://learn.microsoft.com/dotnet/fundamentals/code-analysis/quality-rules/ca1068)

Remove this unread private field '_rowNumber' or refactor the code to use its value.