In short what i want to do is, create several worksheets dynamically, populated with data from a database result. So far i'm getting: Fatal error: Call to undefined method PEAR_Error::write() in /mnt/hgfs/workspace/CCMS-Web/reports/file-excel.php on line 113 When i'm trying to do this: $workbook = new Spreadsheet_Excel_Writer(); //...
Hi, I am trying to read excel 2007 file through php. I found one such example on PHP COM manual but it only works on windows system since COM objects require MS Excel to be installed. Since I have Linux machine that code doesn't work for me. Does anybody know the workaround for this? Due to some restrictions, I don't want to use any ...
I have a workbook with two spreadsheets. One is 'Daily Profit and Loss' and looks like this: Date | Profit 01/01/01 | £1 01/02/02 | £-1 And another is 'Weekly Profit and Loss' Week Beginning | Profit ... How can I get the sum profit per week in the 'Weekly Profit and Loss' spreadsheet? Cheers, Pete ...
I have to read clipboard from a .net application using c#. I use "Xml Spreadsheet" format to read it to have informations like type of columns. My problem is that sometimes the GetData() return null. Stream stream = Clipboard.GetData("XML Spreadsheet") as Stream; I read clipboard from the main thread. I suppose this is a memory proble...
I am trying to migrate users off of a sharepoint solution into a website + SQL backend. The one thing is that everyone seems to like the sharepoint view and the data sheet view for editing and managing information. what is the best spreadsheet / access data editing solution. are there any third party asp.net mvc widgets that are good ...
http://code.google.com/googleapps/appsscript/class_range.html#getFormula Is there a script I can install or do I need to write my own? After that? ...
How can I import an excel file into my SQL database? I have two options, MSSQL or MySQL. Thank you ...
Hi, We are currently using PHP Spreadsheet_Excel_Writer library for generating excel sheet based reports. The library is consuming a lot of memory/time when we are trying to generate reports containing 20k-25k rows. Many times it takes above 20 sec for generating a file. Any suggestions on which library can be used instead of Spreadsh...
I have a function in a controller that takes in some specifications and generates a report on them. This function user_report is called in a view: < %= submit_to_remote 'submit-button', "Export Report to Excel", :url => { :controller => :reports, :action => :user_report, :print_state => 'print'} % > In reports_controller I use the Spr...
Hi - I'm trying to work out the best way to display a Google spreadsheet in the members section of a website. Although the info in the spreadsheet isn't hugely sensitive, I'm not keen on publishing it and embedding it using an iFrame, so am trying to find a way to embed the spreadsheet while still keeping it private. I've tried using t...
I'm using Asp.net to create a csv file that the user can open directly in excel. I want to make it possible to show the download popup and for the user to choose "Open with Excel" and that will open the file in excel. The code to create the csv: Response.Clear(); Response.AddHeader("content-disposition", string.Format("attachment; fil...
I'm jut trying to import a spreadsheet into a table in Access 2000. The spreadsheet is called cc-ledgcodebalances.xls with no field names. My code is DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, "tmptmp", VFileName, 0 This seemed to work once but since then I now get this; The Microsoft Jet database engine could not ...
Hello, My application is supposed to parse a text file (relatively easy) and create an excel spreadsheet report. Should I write a stand alone VB.NET application that saves the excel file, or should I use VSTO? I am unsure if there are any differences in terms of ease of development, usability issues, API functions available, etc. Are...
Is there any open source flash based spreadsheet application like google spreadsheets? ...
Suppose I'm writing an ASP.net web application. The original designer of the application was using "PopChart" to make some images appear in the web application. One of the pages had an "Export To Excel" button on it. When the button is clicked, the page content is output to Excel as in this tutorial: http://aspalliance.com/articleView...
I am working with some spreadsheet data and I have a set of cell regions that are of arbitrary bounds. Given any cell, what is the fastest way to determine the subset of regions which contain the cell? Currently, the best I have is to sort the regions with the primary sort field being the region's starting row index, followed by its en...
Hi to all. I have a problem with reading .xlsx files in asp.net mvc2.0 application, using c#. Problem occurs when reading empty cell from .xlsx file. My code simply skips this cell and reads the next one. For example, if the contents of .xlsx file are: FirstName LastName Age John 36 They will be read as: First...
I'm trying to find a way to from a Cell get the data from a cell in the Sheet that lies to the Left (down in the tray) of the current Sheet. I know how to call to other sheets via =Sheet1!A1 But now I need something best explained with =Sheet[-1]!A1 Any ideas? ...