All Questions
18 questions
6
votes
4
answers
172
views
an algorithm that chooses the best games on steam
The code below will go through an excel spread sheet taken from kaggle, is named "SteamGames (71k games)" and the creator is "MEXWELL".
inside the ...
- 587
2
votes
0
answers
52
views
Create a distribution from .xlsx file using Java
I have an Excel file with 2 columns, names and numbers. I want to know for each name what is the probability for each number. I prefer to do it in Java so I would be able to combine it with the rest ...
4
votes
1
answer
611
views
Creating an image in Excel using the colors from an input image
I'm having some performance issues in this code and need some suggestions on how to improve it. I'm not interested in "general code style" improvements unless they have performance implications.
The ...
- 311
3
votes
3
answers
380
views
Apache POI and cyclomatic complexity of code
I have an Excel file, which I am reading using Apache POI APIs; which gives me control over cells/columns in my Excel.
I have around 17 columns in my Excel and these are with different datatypes. I ...
- 131
5
votes
2
answers
5k
views
Create Excel file multiple times with different names
I want to create a new Excel files from an Apache POI object. The filename should contain the standard name, the current date and a counter, if necessary, to prevent collisions. I have a working ...
- 163
2
votes
4
answers
2k
views
Extracting spreadsheet cells using Apache POI
I'm working with Apache POI framework.
This code go through sheets, row and get value of cells. I will try to get value from directly indicated column. I need this because I want convert only some ...
2
votes
2
answers
5k
views
Get a row from Excel with different criterias with one method
Using Apache POI, I want to retrieve a Person from my Excel file by id or by name. To keep ...
- 225
2
votes
1
answer
97
views
Comparing web search results and storing the results in Excel
I'm writing Selenium code in Java. And below is one of the methods.
...
- 123
2
votes
1
answer
456
views
Generic excel Cell processor components
On my job I had the task to process multiple excel sheets, so I tried to make a generic component to make the conversion between the cell values and a java object type.
The first thing that came to ...
- 163
4
votes
2
answers
97
views
Dealing with multiple types in an excel sheet
I need to parse an excel sheet in order to produce an statistic, and some of the columns in the sheet can have different value types within the same column. For example:
...
- 163
1
vote
1
answer
5k
views
Writing a hyperlink to a cell with Apache POI
This code embeds a hyperlink into a cell of your choice of an Excel file.
...
- 113
3
votes
2
answers
466
views
FizzBuzz-type program that reads/writes to Excel
I'm new to Groovy, and coming from PHP it's been a rough transition.
The code below works. However, I would appreciate feedback on how better to write it and follow good practice with Groovy.
I ...
- 133
2
votes
2
answers
3k
views
Multithreaded report generation
I have a requirement where I have to generate some reports read from a database and write the data to Excel.
I want your help in reviewing the following things in my code:
Database connection
...
- 675
3
votes
1
answer
11k
views
Improving performance in generating an Excel file
I am using this code to write more than 170,000 rows to an Excel document. All in all, the file generation process takes about 3 minutes total. (I've already shaved off about ten minutes by shaving ...
- 251
12
votes
3
answers
79k
views
Validate and import data from an Excel file
I have recently designed a module which will do bulk upload for different contents. Basically the user will upload an Excel file, I will have to read and validate headers of excel then each value of ...
- 675