Duplicate table headers and data

Question

Duplicate table headers and data

Opened this issue a year ago · 12 comments

I'm trying to run the first example in the tables tutorial (https://github.com/misterspeedy/FsExcel/blob/main/ExcelTableTutorial.md)

When I look at the output I get one table but where the headers and data are duplicated.
The first set of headers are appended with the '@' character.

I'm using FsExcel package version 0.0.46

Answer 1 · 2023-06-01T14:59:37.000Z

Thanks for reporting this @gmblpnw. I'll see if I can reproduce it. Please could you also upload the .xlsx this generated?

Answer 2 · 2023-06-01T15:48:47.000Z

Thanks for having look at this!
ExcelTableSimple.xlsx

Answer 3 · 2023-06-01T16:52:50.000Z

Ok, I see the same issue when I open your uploaded sample, thank you. Still investigating.

Answer 4 · 2023-06-01T16:56:58.000Z

I ran the example locally, the problem did not reproduce. Very strange.

Can I ask you @gmblpnw - what version of ClosedXml did the notebook load, e.g.

Installed Packages
    ClosedXML, 0.101.0
    FsExcel, 0.0.46

Also what OS are you running?

Many thanks.

Answer 5 · 2023-06-01T17:56:47.000Z

Packages:

The OS I'm running is:
Windows 11 Home (10.0.22621 Build 22621)

Answer 6 · 2023-06-01T18:02:43.000Z

So oddly enough when I run the script with FSI (Visual Studio 2022 Community Edition, Version 17.6.2) I get the table header/data duplication.

However when I compile the program and run it as a console application it behaves as expected.

Answer 7 · 2023-06-01T18:07:30.000Z

The F# Interactive version that I'm using is...

Answer 8 · 2023-06-01T18:29:18.000Z

Curiouser and curiouser. Thank you!

Answer 9 · 2023-06-01T20:59:47.000Z

Looks like I'm also getting the same behavior using F# Interactive from the command line under WSL2 / Ubuntu 22.04.1
where the FSI version is 12.4.0.0 for F# 7.0

Answer 10 · 2023-06-01T21:11:27.000Z

I just tried using F# Interactive again on WSL2/Ubuntu 22.04.1
This time I downgraded dotnet from 7.0 to 6.0 where the FSI version is 12.0.0.0 and FSharp.Core was 6.0.1

This time the result was as expected! No duplication of headers / data

Answer 11 · 2023-06-01T22:01:20.000Z

Nice work! Do you think this might be a dotnet 7 bug? Tomorrow I might try repro-ing from C# in https://dotnetfiddle.net to eliminate the FsExcel/F# Core aspect altogether.

Answer 12 · 2023-06-02T13:27:00.000Z

I guess I'm wondering if the bug is somewhere in F# interactive. The code runs fine under dotnet 7 when compiled into a console app. It's only when the code is run directly in F# interactive that the problem crops up.