• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Bear Bibeault
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Piet Souris
  • salvin francis
  • Stephan van Hulst
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Jj Roberts

Using Excel with Java

 
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Marshal
Posts: 26128
77
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't see why you can't insert a column. It may be that the API doesn't have an "Insert Column" method to do it in one line of code, but that shouldn't stop you from doing it the hard way, I don't think.
 
Ardel Grider
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
@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
 
I wasn't selected to go to mars. This tiny ad got in ahead of me:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic