Excel sheet charts

Hello,

I have to plot charts in excel sheet. I don’t know where the data is
stored so row information and how much is the data info is not known in
advance. Rows and Cols get computed based on the length of the data
records, which can vary every time. I tried following but it didn’t
work:

Suppose
VariableX = 1
VariableY = 10
excelBrowser.Range(“A#{VariableX}:B#{VariableY}”).Select()

Any suggestions.
Thanks,
Swar

Swarup Swarup wrote:

Hello,

I have to plot charts in excel sheet. I don’t know where the data is
stored so row information and how much is the data info is not known in
advance. Rows and Cols get computed based on the length of the data
records, which can vary every time. I tried following but it didn’t
work:

Suppose
VariableX = 1
VariableY = 10
excelBrowser.Range(“A#{VariableX}:B#{VariableY}”).Select()

Any suggestions.
Thanks,
Swar

Hi Swar,
Could you maybe flesh out your question a little bit? It’s not entirely
clear what you are asking, at least to me.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs