Ardel Grider

I have an application that gets the login user's name from windows and checks that name against a database to alert the user when their username comes up. I am now attempting to create a program that does the same thing but it will pull the Citrix username instead when you launch it through Citrix. Does anyone here have experience doing that or if this is possible. I am having a hard time finding this online. Thank you for any help.

I think I will start by applying what I can and move forward from there. Thank you very much for all the info and resources to assist me with this process.

Thank you both for the suggestion. I have been doing research on it and trying to figure out the best way to apply it to my issue but it is just not clicking. Is there a particular resource you would suggest learning from?

I have been programing in java full time for a year now and one thing i keep finding is I have having a hard time finding some really easy to spot mistakes. Currently in my process I will get a request, Layout what needs to be done, create the SQL code (When I am writing to read from our database) and verify it, Create the GUI, then I will test the program and modify code several times. Then I get what I believe to be the final result and send it out. A week or two later some one comes to me and ask why X is not working. I take a look and it was over something really dumb like I put in a 7 instead of a 2. Or I referenced the wrong variable.

So my question is what do you guys do to avoid these small mistakes from hitting production?

I started out using 3.15, I have tried 3.13, 3.14, and 3.16 with the same issue. I have reported this on their site as a bug on to Microsoft community since excel is crashing.  

POI Bug

Microsoft Community

I have went in and manually added the filter and it has no issues. I have also found that if I add the filter thru my code then I open the sheet and filter then sort it then it won't crash. But if the first thing I do, after it runs thru my code, is sort then it crashes every time.

I have been on there trying to modify it toconvert with the links you provided and I keep running into issues. I am going to keep trying the conversion method unless you have another idea that could resolve this?

Hey guys, I am working on a program that opens an excel sheet, adds auto filter to row 5 then closes. I have it to where it does that perfectly but once you open the sheet and try to sort it crashes. I have found that if it is the XLSX type of excel sheet then it works and doesn't crash. But due to the our SSRS reporting server creating the file then it will be an XLS type and thus causing the crash. I have tried to convert it from HSSF to XSSF but I have failed every time. What would you guys recommend I do to resolve this?

    try {   FileInputStream fileIn = new FileInputStream("C:\\Users\\gria\\Desktop\\Fleet Manager Summary.xls"); HSSFWorkbook report = new HSSFWorkbook(fileIn); Sheet sheet = report.getSheetAt(0); sheet.setAutoFilter(CellRangeAddress.valueOf("A5:O5")); FileOutputStream fileOut = new FileOutputStream("C:\\Users\\gria\\Desktop\\Fleet Manager SummaryT.xls"); report.write(fileOut); fileOut.close(); fileIn.close(); } catch (Exception e) { e.printStackTrace(); }

Thank you,

@Carry The problem I am having is not with my code but with the API its self due to its limitations based on the information i have found.

@Paul From what I have seen on a few Stack Overflow posts you can not Insert a Column. So I am trying to come up with the best work around. What is this hard way you are referring to? Have you used the Apache API before?

Here are some examples of results I have found with my research.
http://stackoverflow.com/questions/4199096/apache-poi-how-to-insert-column-in-excel-file
http://stackoverflow.com/questions/28394100/adding-column-to-excel-using-apache-poi
http://apache-poi.1045710.n5.nabble.com/Adding-Deleting-a-Column-td2309908.html

Hello everyone, I am working on learning to use excel with java and I have ran into a stumbling block. It seems I can not insert a column using Apache API and thus can not update the excel sheet. I believe I have came up with a work around when I write and run a VBA script that I will call from the java program that will insert all the columns I need and them update it from there. Do you guys think this would be a good solution or do you guys have a better work around you came up with?

Hey guys I am trying to find a way to copy and insert about 2,100 cells using the Apache API for excel. It is for a revenue report that my boss is wants auto generated. I believe I have found how to copy the cells but can not figure out how to insert them. The code I have been working on is posted below.
InputStream inp = new FileInputStream("C:\\Users\\gria\\Desktop\\GrossRevenueCopy.xls"); Workbook report = WorkbookFactory.create(inp); Sheet sheet  = report.getSheetAt(6); CellRangeAddress values = new CellRangeAddress(0, 300, 3, 9); // This gets the range of cells I need to copy. values.copy(); // I am not sure what this does but I belive it has to do what I am looking for. //Possible finding away to dump it into an Array of some kind System.out.println(values.getNumberOfCells()); // 2107 //Once I get the data then I can create the cells and add insert the data

Adding the full path to the Jar worked. Thanks guys.

Here is what is going on. I have created a .Bat file containing start javaw -jar BTG_Producer.jar When I start this manually by double clicking it will show my java program in my system tray and shows the process "javaw.exe *32" in Windows Task Manager. When I run this thru Task Scheduler it starts the process "javaw.exe" with out the *32 and does not show the program in the system tray. Nor is the program seem to be running at all with the expetion of the new process in task manager. Do you guys know what I am doing wrong?

I had it in a source folder and was using Class.getResourseAsStream(). I deleted the folder and readded it and it now works not really sure why though.

Thanks guys. Running it by command line shows that it can't find the image I am trying to use as my System tray icon. Thanks again for the help.

Hello guys, I have created a program that just sits all pulls data and feeds it into another program. When I export the program that pulls the data into a run-able JAR and try it launch it it does not do anything. It has no GUI but it should put an icon in the system tray and be in the processes. I exported the second half of the program, it has GUI, the same exact way and it runs perfectly minus the failed connection part. What is the best way to trouble shoot this to see what is going on?