I have a code that writes data to excel using setcontentype(application/vnd.ms-excel)
Now I want one of the columns to be formatted to currency.
I do not intend to use any additional jars(POI, etc).
Is it possible to achieve the task.
It is possible, but you would have to know hell more about the structure of Excel document, so you better to use POI otherwise it is likely to take months. Can you explain why you do not want to use any available libraries?
Yes the app was designed to generate basic excel files. And there is a whole lot of coding that already exists and which will need to be replaced if I use libraries like POI.
Therefore I need to do this without using any libraries.
Is it possible?
Of course it is possible how would people actually put together POI or similar. Question is for you to answer to your self or your boss is it really worth to do it hard way...
For me answer is clear, use POI and just provide data to create Excel documents on the fly. I do not need to learn about Excel document format, don't have to come up with routines to insert data into cell, row, column etc.
Need some help with this Array. I am trying to get the sum of the even numbers and the sum of the odd numbers using a for each loop. I know the answers to what I am trying to achive are sum of even = 84 and the sum of ...
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...