Opening Blob Excel file

upasanisandip

Hi all,
I have stored a excel file as BLOB.
How can I open excel BLOB file.

Any suggestions , hints are welcome.

thanks,
sandip.

kine

You need to export it into file and open the file...

upasanisandip

kine , thanks for reply,
You mean to say I have to use Excel buffer table for this? or is there any other method also?

punossound

What I think kine was saying is to export the file inside blob, then you can open it with SHELL command. For some tips and tricks on using SHELL you can use this one http://www.mibuso.com/forum/viewtopic.php?t=12417

kine

punossound wrote:

What I think kine was saying is to export the file inside blob, then you can open it with SHELL command. For some tips and tricks on using SHELL you can use this one http://www.mibuso.com/forum/viewtopic.php?t=12417

Exactly, you need to save the blob back as file and open it as a file. (EXPORT function of the BLOB field).

Ravi_Thakkar

Hi all,

Can we open the file directly without exporting it to HDD?
If yes then specify how.

Pease help me.

garak

no. because you can't send a stream from toe BLOB directly to the Workbook (as i know).

Ravi_Thakkar

Hi garak,

Thanks for your help. But Whichever thing i required is possible which i recently found on following forum.

viewtopic.php?f=23&t=3344

Please refer it, it's the nice soln.

Thanks to all.