spreadsheet
Create an Excel Spreadsheet from a Oracle Database
I have a table in a Oracle d开发者_Go百科atabase. I have to create a complex spreadsheet structure from the Oracle table. I am looking for best approach to achieve this. Can I use SSIS or use some Ora[详细]
2023-03-06 11:15 分类:问答How can I format a specific cell using the Ruby Spreadsheet library?
Formatting a column or row seems to be no problem.I\'ve poked around the documentation a bunch, did some searches, and looked through the \"methods\" result on some spreadsheet objects and I can\'t fi[详细]
2023-03-06 06:31 分类:问答PHPExcel very slow - ways to improve?
I am generating reports in .xlsx using PHPExcel. It was okay in the initial testing stages with small data sets (tens of rows, 3 sheets), but now when using it on a real production data with over 500[详细]
2023-03-05 06:47 分类:问答Rails "can't convert Spreadsheet::Workbook into String"
I\'m trying to use the spreadsheet gem in my Rails app, but I get the following error: can\'t convert Spreadsheet::Workbook into String[详细]
2023-03-04 17:11 分类:问答How do I create a histogram where the bar heights cover a range of values (preferably in Open Office Calc )?
I have a spreadsheet that contains data that ranges from 0.0 to 1.0, e.g开发者_运维问答. a, 0.1[详细]
2023-03-02 09:17 分类:问答Generate a spreadsheet file on iOS that is readable both by Excel and Numbers
I need to generate a spreadsheet file on iOS that is readable both by Excel and Numbers. CSV file is not sufficient as it does not allow multiple sheets and/or formatting.[详细]
2023-02-28 21:02 分类:问答How can I copy table cells in excel style using jQuery?
excel has a nice feature which allow that cells to by copied by a mouse drag and drop.The same functionality is offered by Google spreadsheet.[详细]
2023-02-22 07:30 分类:问答How to read a spreadsheet with WSH?
I need to read some cell values from a .xls file using JScript under WSH. Is there any COM object or anything that I can use to do tha开发者_开发技巧t?Actually there is a COM component for this. Its[详细]
2023-02-21 21:17 分类:问答Perl Excel preview problem in Outlook
I am generating Excelreport in Perl. I am usi开发者_StackOverflowng the Formula in the cell, it\'s working fine, but in Outlook when I see through preview file, the cell is showing something like Spr[详细]
2023-02-20 07:40 分类:问答CSV file formatting options during creation
I have the fo开发者_开发知识库llowing code which contains data for the csv file.Now i want the data to be displayed aligned left for all the columns.[详细]
2023-02-19 12:48 分类:问答