brinco

brinco

I’m trying to dynamically generate a XLSX file, using elixlsx and I’m doing it, but the file generated doesn’t have any file extension, i.e. I just download a file called download and I’d like to download download.xlsx. Can someone help me. please?

My current relevant code is:

config/config.exs

# Configures xlsx mime type
config :mime, :types, %{
  "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" => ["xlsx"]
 }

web/router.ex

defmodule Backoffice.Router do
  use Backoffice.Web, :router

  pipeline :browser do
    plug :accepts, ["html", "xlsx"]
    plug :fetch_session
    plug :fetch_flash
    plug :protect_from_forgery
    plug :put_secure_browser_headers
  end

  pipeline :api do
    plug :accepts, ["json"]
  end

  scope "/", Backoffice do
    pipe_through :browser # Use the default browser stack

    get "/",         PageController, :index  
    get "/download_form", PageController, :download_form 
    get "/download",   PageController, :download
  end
end

web/controllers/page_controller.ex

defmodule Backoffice.PageController do
  use Backoffice.Web, :controller

  def index(conn, _params) do
    render conn, "index.html"
  end

  # render download form
  def download_form(conn, _params) do
    render conn, "download_form.html"
  end

  # generates XLSX
  def download(conn, _params) do
    render conn, "download.xlsx"
  end
end

web/views/page_view.ex

defmodule Backoffice.PageView do
  use Backoffice.Web, :view

  import Elixlsx
  alias Elixlsx.Workbook
  alias Elixlsx.Sheet

  def render("download.xlsx", _params) do #, %{tweets: tweets}) do
    Workbook.append_sheet(%Workbook{}, Sheet.with_name("Sheet 1")
    |> Sheet.set_cell("A1", "Hello", bold: true))
    |> Elixlsx.write_to_memory("download.xlsx") |> elem(1)  |> elem(1)
  end
end

Showing Posts 1 to 3

OvermindDL1

OvermindDL1

I’m not seeing where you set the name there? By default the name will be the last part of the path of the url (‘download’ in your case) but you are not setting it to “download.xlsx” anywhere. The line render conn, "download.xlsx" is just calling a render template of “download.xlsx”, not setting a name for note.

To set a name just do normal http stuff. :slight_smile:

The recommended usual way that should work in every situation is to just set a header with a key of “content-disposition” and a value of “attachment; filename="download.xlsx"”, which you could do via (for example):

  # generates XLSX
  def download(conn, _params) do
    conn
    |> put_resp_header("content-disposition", "attachment; filename=\"download.xlsx\"")
    |> render("download.xlsx")
  end

I think I have that right. :slight_smile:

brinco

brinco OP

Thanks, man!

sergey-chechaev

sergey-chechaev

I create a little post about how to export data to XLSX report in you Phoenix application https://medium.com/@SergeyChechaev/elixir-phoenix-everyday-tips-create-xlsx-66cd70268eb4#.bbegm57hq

— All posts loaded —

Where Next? Top

Trending in Questions Top

stjefim
Hello! Suppose you are building workflow (order / task / payment) processing system with the following requirements: Each workflow con...
New
jonnycharles
I’m in search of an Elixir library that offers PDF generation capabilities similar to Ruby’s Prawn. While there have been discussions abo...
New
Blokh
Hey guys, I’ve got a huge CSV ( around 10 GB ) that needs to be processed hourly Do you guys have any suggestions what is the best prac...
New
roeland
Kia ora, We have been using elixir-google-api to connect to Google Drive. However, with the updates to Tesla due to CVEs this is now bro...
New
subsaharancoder
I’ve followed the Phoenix LiveView file upload code here Uploads — Phoenix LiveView v1.0.0-rc.7 and so far everything works just fine wit...
New
jaybe78
Hello, I’m developing a online persistent chat system (what’s app) like using elixir/dynamodb/aws for a mobile app(flutter). The diffic...
New
mohsen
I’m using an Umbrella project for a Phoenix application, and I want to have one Ecto Repo and one PostgreSQL database shared by all apps....
New

Other Trending Topics Top

JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
mcass19
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New
netoum
Corex is an accessible, unstyled UI component library for Phoenix that integrates Zag.js state machines using Vanilla JavaScript and Live...
New
Damirados
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve. They are GUI (Emerge) and State management (S...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews