excel
Looking for changes in cells - Excel files
I have 2 excel files with a lot of data in each. The data is structured exactly the same in both files but the values might have changed as the data is from two different times.[详细]
2023-04-11 04:09 分类:问答Error 3021, no current record has been found, Query data from Access to Excel
I\'m writing a function in Excel VBA which will be called to extract data from an Access database, I\'m using ADO connection. The function Get_g_gtop has parameters defined as bellow. Now, I try to us[详细]
2023-04-11 03:56 分类:问答Insert large amount of data efficiently with SQL
Hi I often have to insert a lot of data into a table. For example, I would have data from excel or text file in the form of[详细]
2023-04-11 02:44 分类:问答How to decode %C3%B8 in vba
How do i decode %C3%B8 in VBA? it is the danish letter ø - I开发者_运维问答t is encoded in UTF-8. I have tried to decode it in vba for use in a excel sppreadsheet with the following function:[详细]
2023-04-11 02:25 分类:问答Click RefreshWorkbook on Bloomberg Ribbon [duplicate]
This question already has answers here: Closed 10 years ago. Possible Duplicate: How to refresh/load RTD Bloomberg function (BDH) in excel in vba[详细]
2023-04-11 02:23 分类:问答Django Spreadsheet Application
I am in the making of a Django application where you will be able to upload an excel spreadsheet file and have it inserted into the application. But I sorta got the importingsorted out.[详细]
2023-04-11 02:08 分类:问答How to split a string with multiple delimiters in vba excel?
I want to split a string with multiple delimiters using Excel VBA.One of the strings is: d1-d2 d3 d4 We have a dash and a space as two delimiters. I tried the split function but it only do开发者_如[详细]
2023-04-11 01:54 分类:问答Excel: Data validations with dynamic range from separate worksheet
I am trying to create a data validation list whose source comes from a dynamic range on another worksheet. For instance, take the following layout[详细]
2023-04-11 01:16 分类:问答Excel datevalue
How do I convert a date string 2019-06-20T00:00:00+01:00 to an Excel date? D开发者_JAVA百科ATEVALUE returns #Value when I try this in Excel.[详细]
2023-04-11 01:05 分类:问答Setting an Excel worksheet's custom page size (not the printable area) from Perl
Long story short, all I\'m really attempting to do is print my reports on half sheets. I had Kinko\'s chop a pack of printer paper in half and my laser printer is perfectly happy to suck them in and p[详细]
2023-04-10 23:57 分类:问答