Code Monkey home page Code Monkey logo

trx2excel's People

Contributors

rahulrathore44 avatar scout208 avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

trx2excel's Issues

Flat list of all test results in single sheet

Hey @rahulrathore44 !
I appreciate your work in this repo ๐ŸŽˆ

Why do create sheet per namespace? For me, a better way is to just list all my test result (across test namespaces) in a single sheet,
in a simple table where I can further process.
What do you think?

getting Exception like System.ArgumentNullException: Value cannot be null.

C:\Users\ajay.b\Downloads\Trx2Excel-master\Trx2Excel-master\Trx2Excel\bin\Debug> Trx2Excel.exe "C:\Users\ajay.b\Downloads\trx2html\sourceCode\sourceCode\TRX2HTML Solution-DEV10\trx2html\test\SampleTestResult.trx" "C:\Users\ajay.b\Downloads\abc.xlsx"

I had used above text in Command line but it throws exception like : -

Unhandled Exception: System.ArgumentNullException: Value cannot be null.
Parameter name: value
at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
at Trx2Excel.TrxReaderUtil.TrxReader.GetResult(XmlDocument doc, XmlNode node) in C:\Data\GitHub\Trx2Excel\Trx2Excel\TrxReaderUtil\TrxReader.cs:line 45
at Trx2Excel.TrxReaderUtil.TrxReader.GetTestResults() in C:\Data\GitHub\Trx2Excel\Trx2Excel\TrxReaderUtil\TrxReader.cs:line 35
at Trx2Excel.Program.Main(String[] args) in C:\Data\GitHub\Trx2Excel\Trx2Excel\Program.cs:line 21

plz help regarding to this issue.....

System.InvalidOperationException

Eccezione non gestita: System.InvalidOperationException: A worksheet with this name already exists in the workbook : GeoPlus.TestSuites.Recapito.Rec
in OfficeOpenXml.ExcelWorksheets.AddSheet(String Name, Boolean isChart, Nullable1 chartType, ExcelPivotTable pivotTableSource) in OfficeOpenXml.ExcelWorksheets.Add(String Name) in Trx2Excel.ExcelUtils.ExcelWriter.AddSheetToExcel(Dictionary2 filteredData, ExcelPackage package, String nameSpace) in C:\Users\matbellara\Documents\TRX2EXCEL\Trx2Excel\Trx2Excel\ExcelUtils\ExcelWriter.cs:riga 63
in Trx2Excel.ExcelUtils.ExcelWriter.WriteToExcel(List`1 resultList) in C:\Users\matbellara\Documents\TRX2EXCEL\Trx2Excel\Trx2Excel\ExcelUtils\ExcelWriter.cs:riga 55
in Trx2Excel.Program.Main(String[] args) in C:\Users\matbellara\Documents\TRX2EXCEL\Trx2Excel\Trx2Excel\Program.cs:riga 28

Unhandled Exception with long namespaces

If you are using long namespaces, you can run into folowing error:

Unhandled Exception: System.InvalidOperationException: A worksheet with this name already exists in the workbook : TestsCjm.Tests.HF_Upgrade.C1027
   at OfficeOpenXml.ExcelWorksheets.AddSheet(String Name, Boolean isChart, Nullable`1 chartType)
   at OfficeOpenXml.ExcelWorksheets.Add(String Name)
   at Trx2Excel.ExcelUtils.ExcelWriter.AddSheetToExcel(Dictionary`2 filteredData, ExcelPackage package, String nameSpace) in C:\Trx2Excel-master\Trx2Excel\ExcelUtils\ExcelWriter.cs:line 64
   at Trx2Excel.ExcelUtils.ExcelWriter.WriteToExcel(List`1 resultList) in C:\Trx2Excel-master\Trx2Excel\ExcelUtils\ExcelWriter.cs:line 56
   at Trx2Excel.Program.Main(String[] args) in C:\Trx2Excel-master\Trx2Excel\Program.cs:line 24

The program tries to create a new sheet for every namespace, but excel allows names with max length 31 characters and discards the rest. That can cause duplicit sheet names which results into beforementioned error.

Workaround with limitation
replace main content of Trx2Excel.ExcelUtils.ExcelWriter.FilterTheDataWithNameSpace with return new Dictionary<string, List<UnitTestResult>> { { "Resuls", resultList } }; and recompile ...
which will display all results on single sheet

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.