Ulf Dittmer wrote:You mean you're not using a library like jExcelApi or Apache POI? If so, is it really an Excel file that you're creating? Or an HTML or CSV file that happens to be opened by Excel?
Either way, what does "add some note at the end of the file that can be changed at any time" mean? What is "some note" - text in a cell? And who would be changing it - a human being? Code running on the client or the server?
You need to TellTheDetails.
Ulf Dittmer wrote:Well, if you manage to have the CSV file be opened by Excel on the client, then the user would have no problem using any of Excel's functionality (including adding any text in any cell she chooses). it won't get saved in any way, of course, unless she saves it locally. Is that what you mean by "add some note at the end of the file that can be changed at any time"?
Ulf Dittmer wrote:I still can't tell whether this changing/adding of values would happen programmatically on the server or manually on the client? If the former, there should be no problem to stream the values the next time the CSV is accessed, no? If the latter, the values wouldn't be saved unless you somehow upload/save them to the server.
I want my controller to get the data from property file or jsp file to and show it in excel sheet.
if i use property file i can display as i want so i want to useJSP.
Ulf Dittmer wrote:
I want my controller to get the data from property file or jsp file to and show it in excel sheet.
Firstly, please drop the references to "Excel sheet". If you create CSV, then that's what you have - CSV, which is not an Excel file. It doesn't matter what application is used on the client side to open it.
Also, what does "get the data from JSP file" mean? JSPs are used for generating character data (like HTML or CSV) - they are not a *source* of data.
if i use property file i can display as i want so i want to useJSP.
I don't understand what you're asking; can you rephrase it? What does emitting CSV from a JSP have to do with where the data comes from, and why would that make any difference?
prob: 1/my CSV file has/display list of values that come from database and 2/i want to add foot note the CSV at the end of that file.
3/this foot note content supposed to come from JSP but 4/i can not access JSP from controller.
Ulf Dittmer wrote:
prob: 1/my CSV file has/display list of values that come from database and 2/i want to add foot note the CSV at the end of that file.
That much is clear.
3/this foot note content supposed to come from JSP but 4/i can not access JSP from controller.
You keep saying that data "comes from the JSP", but again, JSPs are not a source of data - data flows *into* a JSP when the HTML/CSV is generated at the server, but data doesn't *come out* of it.
Do you maybe mean that data is submitted by an HTML form on the client, and that that data should be added to the CSV next time it is generated?
Yes data should come from HTML and added to CSV file. but that data is not given by client but he is supposed to get from application based the options choosen from application.
In other words, data or footnote in cvs file changes based on the client chosen options.
OK, so there's an HTML form in which the user selects something, and based on that some data is appended to a CSV file the next time that's streamed to a browser. What do you have so far? Where are you stuck making progress?
i am not able to add some content in the CSV
Ulf Dittmer wrote:
i am not able to add some content in the CSV
Why not? Your code creates the CSV, doesn't it? Why can't it add another line at the end that contains the extra data?
Hey! You're stepping on my hand! Help me tiny ad!
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
|