Android Question How to OPEN .xls file from dropbox .. not download

[TMa]

Hi

I want straight to open .xls file from dropbox ..
Ihave tryed this:
---------------------------
Dim p As PhoneIntents
StartActivity(p.OpenBrowser("https://www.dropbox.com/something.xls"))
-----------------------
But it only force me to download file.. How I can I straight open it with my default .xls viewer ?

 

[NJDude]

You will have to download and then open.

 

[TMa]

ok .. so I click my button ... and from dropbox there comes text "download" .. then I have to accept it. And I open it from its download location with some code.
BUT ... is there then a way to download without accepting it .. so download and open is then automatic.

In my dropbox is file and it updates sometimes.. and I want allways open newest version from there without any extra download buttons.

I hope you understand what I mean

Or is that problem from dropbox.. so I just have to allways accept that download

 

[Erel]

You can use HttpUtils2 to download the file.

 

[TMa]

I tryed some examples what I found but cant't get those work.. it says Error description: Unknown type: downloaddata
I have trying this example http://www.b4x.com/android/forum/threads/download-huge-files-with-httputils2.30220/
http://www.b4x.com/android/forum/threads/download-huge-files-with-httputils2.30220/
How can this easy thing be so hard

Now i have to accept that download and then program opens it when I press back button.
but still trying to do straight download and open it.

 

[Erel]

Dim j As HttpJob
j.Initialize("j", Me)
j.Download(<your link>)

Sub JobDone(j As HttpJob)
 If j.Success Then
  Dim out As OutputStream = File.OpenOutput(File.DirRootExternal, "1.xls")
  File.Copy2(Job.GetInputStream, out)
  out.Close
 End If
 j.Release
End Sub

 

[TMa]

I get error (invalid number of parentheses)
"j.Download(<https://www.example.com/xxx.xls>)"

Do I just put that Erels code to "button1_Click"

I am newbie with this programming, so forgive me that
This is a little bit different than normal basic with commodore 64

 

[DonManfred]

i think it must be

j.Download("https://www.example.com/xxx.xls")

 

[TMa]

yes.. it works better but...
after that it says syntax error in "Sub JobDone(j As HttpJob)"
If I do it like Sub JobDone("j" As HttpJob)
it converts rest of lines with "J" letter to "("
like this
If (.Success Then
and
(.Release

So it still dont even compile..

I have libraries httputils2 and http v1.31 .. same thing both of those.

 

[DonManfred]

the code

Dim j As HttpJob
j.Initialize("j", Me)
j.Download(<your link>)

must be in a sub... sub activity_create for example...

Sub JobDone(j As HttpJob)
If j.Success Then
  Dim out As OutputStream = File.OpenOutput(File.DirRootExternal, "1.xls")
  File.Copy2(Job.GetInputStream, out)
  out.Close
End If
j.Release
End Sub

must be outside an sub.

 

[TMa]

still error here is screencapture of my download test program
https://www.dropbox.com/s/7mej3zkwxx1g6s3/error.jpg

 

[Erel]

You cannot put one sub inside the other.

 

[TMa]

hmm.. now I'm confused
So what i put to button1_click to do that download :/

 

[Erel]

I recommend you to go over HttpUtils2 tutorial and understand how it works.