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.
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...