I read here http://www.daniweb.com/code/snippet217293.html# it is possible.
What should be activated in PHP.Ini or elsewhere to make this work ? Are there any examples with Excel ?
I am developing an Excel project in Access using VBA. My project is working in Access 2007, but it does not work in Access 2003. If I try to run the file, it shows the DLL error. Anyone know how to debug this error?
I've been entering some data into an Excel spreadsheet to work out my monthly earnings, etc. and was wondering how I can I find out how much I'm getting taxed?
Say this is my current spreadsheet:
Hours Worked 37.5 39.5 37.5 30
Hourly Rate $25 $25 $25 $25
Before Tax 937.50 987.50 937.50 750.00
After Tax 260.00 276.00 260.00 ???
How can I use this known data to work out my After Tax pay for the 4th column? :/
I open excel file by JExcel, modify some cells and save it.
As result Array formulas({ ... } CTRL+SHIFT+ENTER) was broken.
Does anybody know what to do? (FormulaException is rasing during copy)
Hi,
having problem with
UnicodeEncodeError('ascii', u'Phase \u2013 II', 6, 7, 'ordinal not in range(128)')
Basically what I am doing here is reading the value from excel sheet
and sheet contain address in this format
Phase- II
So wanted to know how to change`
somestring = u'Phase \u2013 II'
to str
thanks
`
Hi,
I have a SSRS report with full of number fields. I would like to have that to be displayed as in one decimal. i tried to use F1. it gives me only one decimal points in html rendering, but in excel exported version it shows 2 decimal points.
How can i have just one decimal point both ecxel and html rendering.
Please comment.
Thanks in advance
San
Hi, I would like to ask for a recommendation on offline form format which user can bring around. Once done, they will upload the file to the server and data will be extracted from there.
We are currently looking at Word and Excel 2003 since all users have it on their machine but it seems that using interops on server is something to avoid.
Suggestions?
Hey ,Guys!
I want to use the method request.query_string to send the key-value to the controller,how can i use in the sentences;
=link_to 'excel' , reports_excel_path(:format => 'xls',:from => 'conversations')
Thank you!
My .Net application needs to convert PDF document to word format pro-grammatically.
I evaluated several products and found acrobat x pro , which gives a save as option where we can save the document in word/excel format. I tried to use Acrobat SDK but couldn't find proper documentation from where to start. looked into their IAC sample but couldn't understand how to call the menu item and make it execute the save as option. Please help me if you have any idea regarding this.
I need to import either csv or excel file into a dbase. The column headers will match but I will want to compare the file against the dbase using an ItemID field, list the rows to be affected and the differences, then allow an update to all the rows with the matching ID.
For those familiar with Excel, I'm trying to use a similiar NETWORKDAYS function within Cocoa.
Can anyone help with the type of info I'll need to construct an NSDate catagory that can give me only the working days betweek two dates?
many thanks
Nik
I am developing a VBA application which is quite large. I want to use SVN for that application developing.
How can I split my modules from the Excel document and how to upload my modules separately to source control?
Please help me.
hello,
i need to freeze certain columns in listview so when the user scrolls horizontally the frozen columns will not be affected (like in excel) but there is no frozen(bool) property like that in datagrid. Can this be done in listview control? Thanks
Is there a way to run a loop through a folder and process like 30 files for a month and give the average,max of each columns and write in one excel sheet or so??
I have 30 files of size [43200 x 30]
I ran a different matlab scrip to generate them so the names are easy
File_2010_04_01.xls , File_2010_04_02.xls ..... and so on
I cannot merge them as each are 20mbs and matlab would crash.
Any ideas?
Thanks
I have created a shared Add-in for Excel and want to use App.config for some of the settings. I have read somewhere that i cant use app.config for shared Add in(dll). Please let me know is there any other way to read this config file
So I want to make a program that allows you to store and search for user names/passwords for online sites there signed up to.
I know C# has some database options but I don't know much about it. I also heard that it can read/write excel files.
Whats do you think is best for storing the data?
ALSO do databases need to be stored online on a sever, or can they reside in the program
files?
I am looking for ways to implement scrolling in a gridview similar to freepanes in Excel. I need to keep the Header and the first columns static, and enable vertical and horizontal scrolling. I have seen commercial solutions, but I was looking for ways to make it work with the gridview.
can any one please let me know, i need to print/list Alphabetical(A-Z) char to manage Excel cells. Is there any php function to list Alphabetic?
I need result as
A1
B1
C1
D1
...
...
...
OR
A
B
C
...
...
CountIF function in excel , How do I use the same function in
sharepoint Calculated Field.
I want count number of "GO" from Column 1 to Column 12
i.e. Col 1 "GO", Col 2 "GO", Col 3 "No GO", Col 4 "GO": GOs=3
Hi,
I have to load excel file into sql server i use window application so i select filepath in textbox when click button using fileopendialogbox my problem is that i want ot provide list of sheets of file in combo box.
so user can select appropriate sheet to upload. Because it may possible that there are many sheets in file and tool doesn’t know which one to upload.
I'm trying to load external data to my entyity.
DataServiceCollection<products> products = new DataServiceCollection<products>();
var adapter = new OleDbDataAdapter("SELECT * FROM [products$]", "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\products.xlsx;Extended Properties=\"Excel 12.0;HDR=YES;\"");
DataSet ds = new DataSet();
adapter.Fill(ds, "excell");
products.Load(????);
Can anyone help ?
I don't really know how to compose this question. My complay has been using Microsoft ProClarity for few years and we have a quite a few users using it publising books and doing ad-hoc analysis. With the new Microsoft BI solutions, it seems like they are completely going away from ProClarity and replacing the OLAP analysis with Excel. I understand the with SharePoint and integration with PerformancePoint and reporting services the dashboards and reports would be done in SharePoint but what about the analysis? Any ideas?
Case and point: I need to open an Excel file via Interop and it would help a lot to avoid ugly COM errors if I knew that the file was in use.
Other than trying to open the file and catching the exception, is there a programmatic way to determine whether the file is in use?
Hi,
I am wondering if anyone knows a java script library that would add a "select" type of functionality as seen in excel/google docs where you can click and select several different parts of a row and/or column. I am looking at adding this functionality to my web application. Does anyone know where of library's preferably in java script that will be able to add this.
Thanks in advance
MY scenario is... I have 6,000 datas in Excel Sheet.. I try to import to Access Database.It enters the Database like this..
UNit Price 34512.00 Vat 4.00
BUt when i Retrieve to DataGridColumn it Shows vat Rate as 4(whole number).I accept zeros has no values..But I need that to be displayed in Grid as 4.0 . How to achieve this