Uploading excel sheet to sharepoint portal using perl

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each...

2. Shell Programming and Scripting

Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)

Hi folks, I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx). Spreadsheet contains few lines of hyperlink data (pic attached). P.S. Hyperlink is behind the data and not visible in excel sheet directly. Now using perl script I need to copy the hyperlinks in...

3. Shell Programming and Scripting

Perl Reading Excel sheet isssue

There is a perl scriptwhich will read Excel sheet and create one file(.v) . Excel sheet::: A B C D 1 cpu_dailog 2 3 4 Perl will create the file(.v) like thsi ::: assert (cpu_dailog_iso ==2) ; assert (cpu_dailog_reset ==3); assert (cpu_dailog_idle...

4. Shell Programming and Scripting

Perl : Deleting the records in the excel sheet

I have a excel sheet with contains the records as below.. also uploaded the input excelsheet and the output excel sheet(expected output). 322mpls32.net.xyz.comBW: 44.0 M Hrly Avg (IN /...

5. Shell Programming and Scripting

Perl : not capturing all the data from excel sheet

Hi folks, I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month. If it matches current date and month then the matched records are printed as...

6. Programming

Excel sheet modification using perl module

Hi , can any one tell me,"How to extract the same format from existing excel file to new excel file " using Spreadsheet::WriteExcel or Spreadsheet::ParseExcel module ??? Example_pgm: Below program is used to read existing excel file..In this program "my $cell = $_;" line is used to...

7. Shell Programming and Scripting

Excel sheet modification using perl module

Hi , Is there any possibility to read excel sheet in column by column order ?...Thanks in advance,........ :confused:

8. Shell Programming and Scripting

Excel sheet modification using perl module

I need to insert new column to already existing file ..can any one help me..??

9. Shell Programming and Scripting

Excel sheet modification using perl module

Is there any possibility to move the content from one cell to another cell (Excel sheet) using perl module?

10. UNIX for Dummies Questions & Answers

Change the cell background in excel sheet using Perl

I need to change a cell in an excel sheet to different background color using perl. Please help regarding this. Thanks and Regards, Neelam G

LEARN ABOUT CENTOS

spi_cursor_open

SPI_CURSOR_OPEN(3)					  PostgreSQL 9.2.7 Documentation					SPI_CURSOR_OPEN(3)

NAME

       SPI_cursor_open - set up a cursor using a statement created with SPI_prepare

SYNOPSIS

       Portal SPI_cursor_open(const char * name, SPIPlanPtr plan,
			      Datum * values, const char * nulls,
			      bool read_only)

DESCRIPTION

       SPI_cursor_open sets up a cursor (internally, a portal) that will execute a statement prepared by SPI_prepare. The parameters have the same
       meanings as the corresponding parameters to SPI_execute_plan.

       Using a cursor instead of executing the statement directly has two benefits. First, the result rows can be retrieved a few at a time,
       avoiding memory overrun for queries that return many rows. Second, a portal can outlive the current procedure (it can, in fact, live to the
       end of the current transaction). Returning the portal name to the procedure's caller provides a way of returning a row set as result.

       The passed-in parameter data will be copied into the cursor's portal, so it can be freed while the cursor still exists.

ARGUMENTS

       const char * name
	   name for portal, or NULL to let the system select a name

       SPIPlanPtr plan
	   prepared statement (returned by SPI_prepare)

       Datum * values
	   An array of actual parameter values. Must have same length as the statement's number of arguments.

       const char * nulls
	   An array describing which parameters are null. Must have same length as the statement's number of arguments.  n indicates a null value
	   (entry in values will be ignored); a space indicates a nonnull value (entry in values is valid).

	   If nulls is NULL then SPI_cursor_open assumes that no parameters are null.

       bool read_only
	   true for read-only execution

RETURN VALUE

       Pointer to portal containing the cursor. Note there is no error return convention; any error will be reported via elog.

PostgreSQL 9.2.7						    2014-02-17							SPI_CURSOR_OPEN(3)

Shell Programming and Scripting