Posted
by justjoe
on Stack Overflow
See other posts from Stack Overflow
or by justjoe
Published on 2010-03-17T03:43:47Z
Indexed on
2010/03/17
9:41 UTC
Read the original article
Hit count: 191
Can anybody point me to a reference or just explain about how to parse an Excel file in general?
© Stack Overflow or respective owner
as seen on Super User
- Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error,
"This workbook contains Excel 4.0
macros or Excel 5.0 modules. If you
would like to…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format.
I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed.
For this web project I'm building, the server doesn't have office installed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Any ideas why this code will not work?
Workbooks.Open Filename:="C:\a.xls"
Workbooks("a.xls").Activate
Worksheets("b").Select
Dim OutputArray(10, 10)
OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value
I'm trying to run a macro in one file (unnamed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Given the following workbook events:
BeforeClose
BeforeSave
Please tell me:
- The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving.
- What happen if user cancels one of the saving…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to:
pm = ondemand
pm.max_children = 12
pm.start_servers = 2
pm.min_spare_servers = 2
pm.max_spare_servers = 10
pm.max_requests = 500
php_admin_value[memory_limit] = 128M
Problem…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
[root@ip ~]# yum install php-pear*
Reducing CentOS-5 Testing to included packages only
Finished
Setting up Install Process
Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio …
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am taking over an application server and discover that it contain the following settings:
AddType text/html php
Although it works, but my understanding is that it should set as following:
AddType application/x-httpd-php php .php
What are the key differences between the two settings?…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hello.
I have a server with VBulletin forum (working under Apache 2.2, CentOS). The default settings for it in .htaccess are as follows:
RewriteEngine on
RewriteCond %{HTTP_HOST} ^gsmforum\.ru
RewriteRule (.*) http://www.gsmforum.ru/$1 [R=301,L]
# If you are having problems or are using VirtualDocumentRoot…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I have installed memcached fine, and now I will need to install PECL extension memcache. Im running RedHat x86_64 es5. The installation gives me this:
downloading memcache-2.2.6.tgz ...
Starting to download memcache-2.2.6.tgz (35,957 bytes)
..........done: 35,957 bytes
11 source files, building
running:…
>>> More
