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?
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.
posted 3 years ago
@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?