Load Word Excel into WPF
I would like to load a Word or Excel document into a window of a WPF application so that users can view or edit the document within the application. Is there any way to achieve that? ...
excel
How to allow ink in a protected worksheet?
I have an Excel 2003 worksheet with protection enabled being used for data entry on tablet pcs. I'd like to allow users to fill in the contents of the worksheet using ink (and then converting to text), but the ink writing and drawing toolbar is disabled when the worksheet is protected. Is it possible to protect the worksheet and allow in...
Error while generating a PDF file with Excel in ASP.NET
I have to generate an excel file and a PDF file from an asp.net application. I'm using the Interop assemblies and I can generate the excel file without any problem. But when I'm generating an pdf file with the add-in SaveAsPDFandXPS.exe I'm getting the next error: Exception HRESULT: 0x800A03EC with a debug I see the error is in the...
Excel VBA and InternetExplorer causing errors on website
I have some "clever" users who have written an excel spreadsheet that automates some of their tasks on our intranet/timesheet. It seems as if the instance of Internet Explorer that is created is not doing everything I expect a browser to do, e.g. set cookies. Is there a way to detect if a user is hitting a web site with a VBA com object ...
Excel file with multiple sheets from SSRS Reports
Hi, Let's say i have 3 byte arrays, each representin a .xls file. How can i combine them into a single xls file with 3 sheets. The SSRS reports are very rich and include charts sp oledb is not an option. Performance is not important so i could save them to disk if needed, as a last resort i could even use an excel macro (if i knew how ...
how to import a csv or excel to pgAdmin III?
Hi people, How can you import to a table in PgAdmin III from an excel or CSV? Command copy works only when the file is in the server! :S ...
How to generate application forms/documents programmatically?
At the moment, we use MS WORD and MS EXCEL to mail merge documents that needs to be sent to multiple recepients. For example, say there is a complaint form where the complainant needs to fill in his/her name, address, etc. So we have a .doc file set up with the content and the dynamic entities set up for mail merging, with the name and ...
F#, another VBA in Office?
Hi. Excel is a great spreadsheet software, a even greater front UI for Business Intelligence in many companies. Often VBA is used to write the extensions, or to call other DLLs. As Excel itself is functional, F# will company Excel very well to write data analysis procedures. I am thinking whether F# or a variant of F# will become ne...
How Do I Loop Through An Excel Spreadsheet With VBA, Paste A Value To A Website Form Then Extract The Result Back?
I am trying to loop through a list of names in an Excel spreadsheet using VBA and I would like to paste a surname into a text box on a webpage and then extract the returned phone number into a cell after the page has been submitted. I can only do this one name at a time so I would like to automate this process as there are several hundr...
How to determine which DLL an Excel UDF is coming from ?
Hello, is there any way to determine from an Excel session, which DLL an UDF is coming from ? I have a bunch of DLLs loaded by default, I wanted to determine for every UDF where it was defined. If the UDF was not defined in a DLL but via VBA, is there a way to determine in which XLA or XLS it was defined ? Thanks very much for taking...
Excel 2003 (8316.8221) screen corruption
Hi Excel 2003 (11.8316.8221) SP3 on Windows XP - KB973475 When the my Excel VBA application starts it activates the first sheet in the workbook but shows portions of the second and third sheet "bleeding" into the first sheet. This is easily worked around by say minimising and maximising the workbook or causing it to repaint in some oth...
excel VBA horizontal alignment problems when using NumberFormat codes
Working on a personal project, When entering a fraction into Excel, I have found that if you don't have an equals sign in front of it then Excel may treat it as a date. I have found that if the cell's format is in fractions then Excel uses it just fine. So knowing this, I went into Excel's VBA and added this to my code: ActiveCell.Nu...
Python to generate output ready for Excel
I have a Python script gathering info from some remote network devices. The output can be maybe 20 to 1000 lines of text. This then goes into excel on my local PC for now. Now access to this Linux device is convoluted, a citrix session to a remote windows server then ssh to the Linux device half way around the world. There is no ftp, sc...
Excel - Highlight active row
Hi everyone, Wondering if there is some preference I can set in excel so that when I am in a specific cell the entire row is slightly highlighted (not overly so but enough to easily tell it out) Similar to the fashion that Notepad++ works in tab delimeted files, and highlights the entire row. Thanks in advance ...
Analysing Excel VBA/Macro code
Is there a tool which will analyse/parse an entire Excel workbook and let us see all the macros, functions, VBA code? I've been given a large number of Excel spreadsheets to analyse, we need to know what they do and how they do it, with a view to creating documentation, and/or re-writing. In many instances the original developers are go...
display preceeding zeros in csv file when viewing in excel
Is this at all possible? If I open up my file in standard text editor e.g. notepad the preceeding zeros are displayed. e.g. 000485001 shows up. Although this doesn't happen in excel. All that's displayed is 485001 Just wondering if there's a way around this? Thanks, ...
connecting excel to an oracle DB
how do i connect excel to an oracle DB? ...
Accessing Excel.ComboBox from C#
Hi, I have a combobox (the drop down list control) in a pre-existing Excel template. I can reference this combobox in VBA with Sheet10.ComboBox1. How can I reference this through Excel Interop in C#? What I am trying to do is populate this combobox/dropdown with C# and have it positioned where I want with the template. Thanks in adv...
Excel validation range limits
When Excel saves a file, it attempts to combine identical Validation settings into a single rule with multiple ranges. This creates one of three issues, depending on the file type you choose to save: When saving as a standard Excel file (Office 2000 BIFF), a maximum of 1024 non-contiguous ranges that can have the same validation setti...
Excel VBA - Find minimum of list of values?
For a list like: Column1 Column2 Column3 DataA 1 1234 DataA 2 4678 DataA 3 8910 DataB 2 1112 DataB 4 1314 DataB 9 1516 How do I get a list like this: Column4 Column5 Column6 DataA 1 ...