excel-2007

相关标签：javascript jquery android 多少钱 iPhone

C# external library (Lua) call problem

I\'m new to programming in C# (VS2010) .Net (4.0) and I\'m encountering I couldn\'t solve by myself since some days already.[详细]

2023-03-23 17:33 分类：问答
SQL SERVER 2008 - SSIS Excel Destination

I am currently trying to use SSIS to export a large dataset into an Excel destination, however the issue that i have for one of my columns is that records within it exceeds that maximum 开发者_运维问答[详细]

2023-03-23 15:51 分类：问答
Linking cells in excel with a specific format

I am trying to link cells in excel on two different work sheets. I am using the formula eg: cell1 = cell2 + cell3. The numbers that I have in cell2 and cell3 are in format of 100% (1) and 50% (2). I[详细]

2023-03-23 10:23 分类：问答
What's wrong with my above Excel-VBA code?

Brief description of what i want my VBA to achieve: I\'m trying to import data from two Excel spreadsheets, and then compare the data on each 开发者_高级运维list to find the missing elements in each l[详细]

2023-03-23 09:36 分类：问答
How to check whether certain sheets exist or not in Excel-VBA? [duplicate]

This question already has answers here: Test or check if sheet exists (23 answers) Closed 4 years ago. Does anyone know how to check whether开发者_StackOverflow中文版 certain sheets exist o[详细]

2023-03-22 22:40 分类：问答
How to avert the save MessageBox prompt in Excel-VBA?

I have a problem here if you look at my codes below after I call the .close line which was the file I initially copied from. It will prompt a save MessageBox message either yes, n开发者_开发百科o, or[详细]

2023-03-22 17:16 分类：问答
How to import Excel related BOM-list content into a excel sheet in Excel-VBA?

How to implement a spreadsheet to do something more dynamic and recyclable for more user to use? By allowing the user to browse and import 2 excel related BOM-list files from the computer local drive[详细]

2023-03-22 07:16 分类：问答
Problem with VBA script reading from MySql database

I am having some trouble with a vba script in Excel which should be reading from a MySql database.The SQL query should only return one[详细]

2023-03-21 18:34 分类：问答
Use openpyxl to edit a Excel2007 file (.xlsx) without changing its own styles?

I have a .xlsx file to edit, I found openpyxl could manipulate Excel 2007 files. I only want to change the value in some cells and leave other settings unchanged.[详细]

2023-03-21 17:31 分类：问答
Making use of selected or clicked cell without VBA

A tricky one, I assume. However, is there a way to make use of a selected or clicked cell in Excel somehow without the need for VBA?[详细]

2023-03-21 06:14 分类：问答