Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Reading contents of a Excel spreadsheet
Fri, Dec 6 2013 2:09 PMPermanent Link

John Postnikoff


I am wanting to read specific cells from a server side Excel spreadsheet in EWB.  This data will be specific to each user or session. I am trying to get up to speed on back-end processing or calling DLLs with EWB.  I am wondering what may be some of the options, if possible.

I have used SMI tools by Scalabium Software that work very well for regular Delphi projects. I am unclear if and how I can do this with EWB. Any insight, examples or doc links will be helpful.


John Postnikoff
Fri, Dec 6 2013 2:35 PMPermanent Link

Walter Matte

Tactical Business Corporation

John:

I have done this - uploading a file from EWB Client.

Then my backend manipulated the spreadsheet - saving parts of it into a database table.  

I use NativeExcel3 Delphi components to manipulate the spreadsheet.  http://nika-soft.com/

The client then is sent back the contents in a EWB Dataset.

Walter


Sat, Dec 7 2013 7:37 AMPermanent Link

Robert Devine

Hi John

I've used various Excel components over the years and can recommend
Flexcel - see http://www.tmssoftware.com/site/flexcel.asp

Superb component...

Cheers, Bob


On 06/12/2013 19:09, John Postnikoff wrote:
> I am wanting to read specific cells from a server side Excel spreadsheet in EWB.  This data will be specific to each user or session. I am trying to get up to speed on back-end processing or calling DLLs with EWB.  I am wondering what may be some of the options, if possible.
>
> I have used SMI tools by Scalabium Software that work very well for regular Delphi projects. I am unclear if and how I can do this with EWB. Any insight, examples or doc links will be helpful.
>
>
> John Postnikoff
>
Mon, Dec 9 2013 2:33 PMPermanent Link

John Postnikoff


I would like to see an example how to use Flexcel or any other third party components within EWB,  To use with Delphi is not a problem.  How to you use or call these components within EWB since I cannot drag and drop a component onto a form as I would with Delphi?  I am not sure how to call these into the EWB project. This is where I am stuck.


Thanks,

John

Bob Devine wrote:

Hi John

I've used various Excel components over the years and can recommend
Flexcel - see http://www.tmssoftware.com/site/flexcel.asp

Superb component...

Cheers, Bob


On 06/12/2013 19:09, John Postnikoff wrote:
> I am wanting to read specific cells from a server side Excel spreadsheet in EWB.  This data will be specific to each user or session. I am trying to get up to speed on back-end processing or calling DLLs with EWB.  I am wondering what may be some of the options, if possible.
>
> I have used SMI tools by Scalabium Software that work very well for regular Delphi projects. I am unclear if and how I can do this with EWB. Any insight, examples or doc links will be helpful.
>
>
> John Postnikoff
>
Mon, Dec 9 2013 3:16 PMPermanent Link

Robert Devine

This would have to be done server-side in Delphi, since that's where
you'd be loading the file. In the past I've just copied the data I need
into a Dataset and pulled it over to the client.

Cheers, Bob



On 09/12/2013 19:33, John Postnikoff wrote:
> I would like to see an example how to use Flexcel or any other third party components within EWB,  To use with Delphi is not a problem.  How to you use or call these components within EWB since I cannot drag and drop a component onto a form as I would with Delphi?  I am not sure how to call these into the EWB project. This is where I am stuck.
>
>
> Thanks,
>
> John
>
> Bob Devine wrote:
>
> Hi John
>
> I've used various Excel components over the years and can recommend
> Flexcel - see http://www.tmssoftware.com/site/flexcel.asp
>
> Superb component...
>
> Cheers, Bob
>
>
> On 06/12/2013 19:09, John Postnikoff wrote:
>> I am wanting to read specific cells from a server side Excel spreadsheet in EWB.  This data will be specific to each user or session. I am trying to get up to speed on back-end processing or calling DLLs with EWB.  I am wondering what may be some of the options, if possible.
>>
>> I have used SMI tools by Scalabium Software that work very well for regular Delphi projects. I am unclear if and how I can do this with EWB. Any insight, examples or doc links will be helpful.
>>
>>
>> John Postnikoff
>>
>
Mon, Dec 9 2013 6:13 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< I would like to see an example how to use Flexcel or any other third
party components within EWB,  To use with Delphi is not a problem.  How to
you use or call these components within EWB since I cannot drag and drop a
component onto a form as I would with Delphi?  I am not sure how to call
these into the EWB project. This is where I am stuck. >>

You should start here:

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=Modules

and here:

http://www.elevatesoft.com/manual?action=topics&id=ewb1mod&product=rsdelphi&version=XE&section=getting_started

And specifically read the Handling Requests section.  What you'll be doing
is creating an EWB module in Delphi (XE or higher) and then filling in the
bits that read the request parameters, do the actual spreadsheet work using
whatever Delphi code/components that you would normally use, and then
returning the result as a string in whatever format that you want (and
designated by the proper content type designation).  After you've created
the module, you'll register it in the EWB Web Server so that it is available
for use:

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=Configuring_Server

(Modules section).

In the front-end EWB application in the browser, you'll be using a
TServerRequest:

http://www.elevatesoft.com/manual?action=viewcomp&id=ewb1&comp=TServerRequest

to specify the URL and any parameters for the EWB module that you'll be
calling.  This is all of the information on how to use TServerRequest
components to make calls to your EWB Module:

http://www.elevatesoft.com/manual?action=topics&id=ewb1&section=using_server_requests

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Image