Given a shared Dropbox link to an Excel file, how can I easily open it in Google Sheets?


I get an email every two weeks with a vendor’s price list as a link to an Excel file in their Dropbox.

At this point, I have to:

  • open the link — This takes me to Dropbox, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer — I have a choice to download to my computer or copy to my Dropbox.
  • upload the file to my Google Drive — To do this I go to any open Google app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google Sheets.
  • copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in Google Sheets is to open the file directly as a read-only file and save a bunch of steps.

My personal account is on Gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

VBS rodando macro do Excel (Problema)

Criei uma macro VBA no excel que roda uma transação no SAP e retorna algumas linhas e popula outra tabela. Essa outra tabela serve como massa de dados para montar gráficos e análises no POWER BI (ferramenta de gráficos da Microsoft). Depois de um tempo eu montei um VBS para fazer com que a macro rodasse e atualizasse os gráficos sem eu precisar abrir o excel, clicar nos botões da macro e tudo mais. Muito bem. Saí de férias e voltei, advinha? Pois é meus caros, o VBS não roda mais. Se eu abrir o excel e rodar a macro tudo funciona porém preciso que rode com o VBS ou talvez um BAT, não sei. Mas esse processo precisa ser feito sem abrir o excel.

Alguma sugestão ?

Set objExcel = CreateObject("Excel.Application")  objExcel.Application.Run "'C:\Users\U546425\Desktop\Customer Center\Complain QNs report.xlsm'!Module1.complain_routine"  objExcel.DisplayAlerts = False  objExcel.Application.Quit  Set objExcel = Nothing 

Obs: Excel 2013 Windows 10 x64

Excel VBA: Looping through table rows and replacing keyterms in word template

So below is my code for a sub which does the following:

  1. read header of a table into an array

  2. reads first row of said table into a 2nd array

  3. loops through the first array and replaces the marked keywords <keyword> in a word template file (.dotx) with the data row cell (includes header and body).

This sub is then called by another sub specifiying both table rows and the template file.

Now since I am not a programmer by profession I am pretty sure that this is far from the best way to do it efficiently, so any comments or improvements are much appreciated.

Sub ReplacefromRange(header As Range, DataRow As Range, TemplateFile)

Dim heading() As String Dim data() As String Dim i As Integer Dim x As Variant  ' Creates a first array that takes "header" as argument i = -1 For Each x In header.Cells     i = i + 1     ReDim Preserve heading(i) As String     heading(i) = x.Value Next x  ' Creates second array that takes "DataRow" as argument i = -1 For Each x In DataRow.Cells     i = i + 1     ReDim Preserve data(i) As String     data(i) = x.Value Next x  ' Uses a for each loop through heading() to find and replace individual entries in the "TemplateFile" argument  i = 0 For Each x In heading()     With TemplateFile                        'looks at the word document body         .Application.Selection.Find.Text = "<" & heading(i) & ">"         .Application.Selection.Find.Execute         .Application.Selection = data(i)         .Application.Selection.EndOf         ' the part below looks at the header content         .Sections(1).headers(wdHeaderFooterPrimary).Range.Find.Execute _     FindText:="<" & heading(i) & ">", Format:=False, ReplaceWith:=data(i), Replace:=wdReplaceAll, Wrap:=wdFindContinue         i = i + 1     End With Next x 

End Sub

Google Spreadsheet: A replacement for Excel Camera Function

I’m getting into Google Spreadsheet after using Excel only for years. While I’m happy with it, there are some parts of Excel I haven’t been able to replace.

One of those is the Excel Camera function.

I tried out inserting Drawings with the cells, but it doesn’t display things like SPARKLINE on the cells and it changes the aspect ratio.

Other than importing the cell range and re-doing my graph into another spreadsheet, is there any solution to this?

Maybe a script or Add-on to insert the tab as an iframe or something of the like?

Thanks in advance.

Best regards, Lucas.


Bom , tenho uma consulta no banco de dados , que me retorna a depender dessa consulta coisa de 5k linhas a 30k linhas , estou gerando já em excel através do código abaixo , contudo quando me traz cerca de mais de 5k de informações , ele demora muito para carregar . Alguém poderia ajudar em relação ao código ou outra forma de gerar o excel ?

excel.php:   <?php    $  file = 'planilha.xls';    header ("Content-type: application/x-msexcel");    header ("Content-Disposition: attachment; filename=\"{$  file}\"" );    header ("Content-Description: PHP Generated Data" ); ?> <?php     define('DB_HOST'        , "");     define('DB_USER'        , "");     define('DB_PASSWORD'    , "");     define('DB_NAME'        , "");     define('DB_DRIVER'      , "sqlsrv");      require_once "Conexao.php";  try{   //inicia a conexao    $  Conexao     = Conexao::getConnection();     $  filial1 = $  _POST[];    $  filial2 = $  _POST[];    $  data_inicial = $  _POST[_];    $  data_final = $  _POST[];      //faz a consulta na tabela procurando palavras do form    $  query       = $  Conexao->query (" EXECUCAO DA MINHA PROCEDURE ");    $  teste       = $  query->fetchAll();    }catch(Exception $  e){         echo $  e->getMessage();         exit;     } ?>     <table border="1">         <thead>             <tr>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>                 <th>                     <center><b></b></center>                 </th>              </tr>         </thead>         <?php         foreach($  teste as $  CLIENTE) {     ?>             <tr>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                  <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE['']; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>                 <td>                     <center>                         <?php echo $  CLIENTE[]; ?>                     </center>                 </td>              </tr>             <?php         }     ?>     </table>      

Importar datos Laravel Excel

Estoy creando un pequeño sistema el cual tiene una funcion de importar un archivo de laravel. He podido lograr lo primero sin problema ahora lo que deseo es obtener el id mediante el número de empleado que viene en una columna del excel pero no he logrado hacerlo ya que cuando consulto la información del usuario para obtener sus datos y poder obtener los registros, la función que recorre el excel deja de funcionar. Adjunto mi controlador:

public function importarIncidencias(Request $  request) {     $  date = new \DateTime();     $  date->format('Y-m-d');     $  quincenaActual=Quincena::where('fecha_inicio', '<=',$  date)->where('fecha_limite','>=',$  date)->first();      $  id_quincenaActual=$  quincenaActual->id;      Excel::load($  request->excel, function($  reader) use ($  id_quincenaActual) {         $  excel = $  reader->get();         // iteracción            $  reader->each(function($  row) use ($  id_quincenaActual) {            $  usuario=User::where('no_empleado', '=',$  row->no_empleado)->first();                           $  incidencia=new Incidencia();             $  incidencia->fecha=$  row->fecha;             $  incidencia->observacion=$  row->observacion;             $  incidencia->tipo_incidencia=$  row->tipo_incidencia;             **$  incidencia->id_usuario=$  usuario->id;**             $  incidencia->id_quincena=$  id_quincenaActual;             $  incidencia->save();                  });      });     return back()->with('notificacion', 'Asistencias registradas correctamente'); } 

El problema se presenta cuando pongo esta linea:

$  usuario=User::where('no_empleado', '=',$  row->no_empleado)->first();   

También quisiera poder contar las filas que se leyeron, pero al ingresar una variable dentro de la función que recorre el excel mi contador no aumenta.


Get Excel of SharePoint

I have a SharePoint DocLib. It contains an Excel spreadsheet I want to send every day at a specific time. Sending a mail every day… is not the problem.

To get this done I’m using Flow to build an automated “workflow”. I achieved to receive single worksheets but not whole .xlsx files. The possibility to open SharePoint for single external people is not in my hand. So this option is not working I guess.

How can I get a copy of a specific file in a SharePoint document library?

Thanks for answers or related topics here (I’ve found none)